i am using ODBC stage to call a stored procedure. it has 2 input parameters and an output ref cursor. i used manager to define metadata, but it only shows two input parameters. when i call the procedure with just 2 input parameters, it gives me error: ORA-06550: PLS-00306: wrong number or types of arguments. when i manually add an output parameter and call it in sp, it gives me the error: ORA-01008: not all variables bound.
i've also defined the columns for the output based on the table definition.
am i missing something?
stored procedure ref cursor
Moderators: chulett, rschirm, roy
when i execute the sp from sqlplus, i have to define a variable:DSguru2B wrote:Are you able to execute the stored proc. successfully and capture the OUT parameter from your favourite sql tool.
sql> variable v refcursor
sql> exec stor_proc (in_par1, in_par2, :v)
it works; and to see the result:
sql> print v