Question and Answer Database
FAQ3737B.txt Oracle 8 and returning the REF CURSOR from a stored procedure
Category :Database(Oracle8)
Platform :Win95/NT
Product : BDE 5.0 (fixed in BDE 5.01)
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:
When using BDE 5.0 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). BDE 5.01 or later resolves the problem.
Last Modified: 16-FEB-00