Hi all,
I'm unable to get the output argument from the stored procedure or function !
Here my PL/SQL procedure code :
Then i have a component wich call the stored procedure :
When i check th database, the insert is done but i'm unable to get/display the val_ouput.
What am i doing wrong?
How to solve this problem?
Thanks in advance,
I'm unable to get the output argument from the stored procedure or function !
Here my PL/SQL procedure code :
CREATE OR REPLACE PROCEDURE procedure_tmp ( val_input IN VARCHAR2, val_output OUT VARCHAR2 ) IS BEGIN INSERT INTO wh_temp (col1 ) VALUES (val_input ); SELECT COUNT (*) || ' record(s)' INTO val_output FROM wh_temp; END;
Then i have a component wich call the stored procedure :
- SQL statment = [CODE]{call procedure_tmp (?,?)}/CODE]
- SQL Parmeter Mapping = val_input,val_ouput
- SQL Parameter Types = in,out
When i check th database, the insert is done but i'm unable to get/display the val_ouput.
What am i doing wrong?
How to solve this problem?
Thanks in advance,