How to get Stored Procedure Out parameter values

If you have a new question you’d like our support staff to post a response to, please visit our customer community, GoAnywhere Insiders, to pose the question in our Discussion Boards. We have a thread “Ask Our Tech Experts” that our support team monitors on a regular basis, or you can start a new discussion where other GoAnywhere users and support staff can weigh in. Log in or create your new account at https://insiders.goanywhere.com.

If you need an immediate response, please create a support ticket or contact our support team by email at [email protected].
2 posts Page 1 of 1

Bhargavi

Posts: 1
Joined: Tue Jan 17, 2017 4:49 pm

Post by Bhargavi » Tue Jan 17, 2017 5:13 pm
Hi All,

I have requirement : Call stored procedure, it has 1 IN parameter and 3 OUT parameters. Based on OUT parameter value i need to implement logic.

using following code to call Stored procedure:
DECLARE
p_last_col_val VARCHAR2(200);
p_errorcode VARCHAR2(200);
p_errormsg VARCHAR2(200);
BEGIN
PROCEDURE_NAME(${param1},out_val,p_errorcode,p_errormsg);
END;

I have created outVariable for this SQL query, but it doesn't have out parameter values. I just returning number of rows affected (-1 or 1 etc)

Can anyone help me out to get rid of this issue.

Thanks
Bhargavi

Support_Rick

Support Specialist
Posts: 592
Joined: Tue Jul 17, 2012 2:12 pm
Location: Phoenix, AZ

Post by Support_Rick » Tue Jan 17, 2017 5:37 pm
The In/Out variables do not work that way through the JDBC connection.

You will need to write the "out" values into a temp table or CSV, then read them (select * from tempTable) or ReadCSV task from within your Project to return those values to your Project.
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
2 posts Page 1 of 1