How to return data structure from stored procedure
Posted
by rodnower
on Stack Overflow
See other posts from Stack Overflow
or by rodnower
Published on 2010-06-13T15:17:45Z
Indexed on
2010/06/13
15:22 UTC
Read the original article
Hit count: 143
Hello, I have C# application that retrieve data from AQ with some oracle stored procedure, that stored in package. The scheme is: C# code -> Stored Procedure in Package -> AQ
Inside of this stored procedure I use DBMS_AQ for dequeue the data to some object of some type. Now I have this object. My question is how I return it? Previously I:
- Created some virtual table,
- Make EXTEND() to table
- Inserted the data from object to table,
- Perform select on the table,
- And return sys_refcursor.
In side of C# I filled DataSet with help of OracleDataAdapter.Fill()
After that I upgraded it to return data fields during OUT parameters. But now I have much fields, and I may not to create so much OUT parameters...
What the best way to do this? Thank you for ahead.
© Stack Overflow or respective owner