Oracle stored procedure

svga · Post by **svga** » Mon Jun 06, 2011 5:40 am

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.

chulett · Post by **chulett** » Mon Jun 06, 2011 5:46 am

Yes. And the "how" of that is documented.

svga · Post by **svga** » Mon Jun 06, 2011 6:21 am

Hi,

In the help documentation, I see that cursor output is available only for DB2 & SQL server.

Thanks

chulett · Post by **chulett** » Mon Jun 06, 2011 6:40 am

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.