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].
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
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
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 Specialist
- Posts: 590
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
-
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.
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
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
2 posts
Page 1 of 1