How to return data structure from stored procedure
- by rodnower
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.