ODBC - Call PL/SQL stored procedure/function - Unable to get OUT parameter

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,