return a recordset with a stored procedure through ODBC
Posted on 2001-07-11
i'm trying to return a recordset from a stored procedure through an odbc connection. it works fine with a standard sql statement but fails when i call a stored proc.
the stored procedure in question executes a normal table query and performs some conditional logic on the returned values and some additional var values are included in the final resultset that the proc returns. i've tried using dbms_output as well as out variables to return the values but neither seems to work through the odbc.
i get an sql error, [ORA-00900].