Hello all,
I have written an Oracle package that contains several Record types, as well
as some functions that return the Record types. I am attempting to invoke
these Oracle functions from a C# application, and I am using the Oracle Data
Provider for .NET (ODP). My question is, how can trap a Record type return
value from the Oracle function? Is it possible to capture the return value
as an output parameter, or is there some other trick?
I'm beginning to fear that there is no mechanism in ADO.NET to receive a
Record (or any other user defined type) return value from an Oracle
function. This would really be unfortunate, as the Record types in my
package contain a good number of fields, making it too cumbersome to expose
all of the fields as OUT parameters. If anyone has an alternative approach
to accessing the Record type via an Oracle subprogram, I'd love to hear
about it.
Thanks for your help,
Michael