Resultset via stored procedure in ORACLE
Quote:
> We have a CRecordset (VC++ 4.2). We are calling a stored procedure
> (ORACLE) via ODBC (Openlink) and would like to obtain a result set as a
> return value /OUT Parameter. We dont get any sensible results when we
> try this.
> Is it possible to do this?
> Thanks for any help
You can't return a resultset from an Oracle stored-procedure.
What you have to do is create a package, define a cursor in
your package, then use the stored-procedure to retrieve
a row everytime you call the stored-procedure. I call this
a persistent cursor. You can only make a cursor persistent
using a package.
-Duc
