How to get Stored Procedure Out parameter values
Posted: 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
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