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.