Hi all,

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,