Page 1 of 1
Oracle stored procedure
Posted: Mon Jun 06, 2011 5:40 am
by svga
Hi,
I have a Orace stored procedure which stores the output results to cursor. So is it possible to retreive the o/p records using Stored procedure stage.
Thanks.
Posted: Mon Jun 06, 2011 5:46 am
by chulett
Yes. And the "how" of that is documented.
Posted: Mon Jun 06, 2011 6:21 am
by svga
Hi,
In the help documentation, I see that cursor output is available only for DB2 & SQL server.
Thanks
Posted: Mon Jun 06, 2011 6:40 am
by chulett
Hmmm... could have sworn that was documented even back in the 7.x days, specifics on how you needed to write the SP to enable this to work correctly. Even for Oracle. Could be wrong and not in any position to check the latest docs myself.
I'm sure someone else will be along and add their two cents soon. That or check with support.