How to get Stored Procedure Out parameter values

Post any question you may have in regards to GoAnywhere MFT and let our talented support staff and other users assist you.
If you need a quicker response, please create a support ticket via the customer portal my.goanywhere.com 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: 590
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