SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

passing stored procedure result set to .NET (alternative to REF CURSOR)??

611859Feb 27 2008 — edited Feb 27 2008

Hello PL/SQL gurus,
I am writing some stored procedures that populate TEMP TABLEs, open REFERENCE CURSOR for that temp table and pass the result set to .NET via reference cursors. This is the only approach I know. Is there any other way I can pass the result set to .NET?? I have to create too many temp tables in database which I don't want.

How do you do this? Please suggest me. Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 26 2008

Added on Feb 27 2008

8 comments

513 views