Question and Answer Database FAQ3737B.txt Oracle 8 and returning the REF CURSOR from a stored procedure Category :Database(Oracle8) Platform :Win95/NT Product : Delphi4.x Question: Using Delphi 4 (w/BDE 5) with the Oracle 8.0.4 client and the Oracle 8 SQL Link driver, I am trying to execute a stored procedure that returns a REF CURSOR type. No matter what I seem to try I get the error "General SQL error ORA-01036: illegal variable name/number" when I try to execute the procedure. What am I doing wrong? Answer: There is a known problem with returning a REF CURSOR type from a stored procedure when using the Oracle 8 SQL Link Driver (in BDE 5.0). We are working on fixing this problem, but currently there is no workaround for this issue. 3/26/99
Last Modified: 01-SEP-99