How to receive a record type return value from an Oracle function?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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


.

Relevant Pages

  • Re: Connection Pooling - tracking users
    ... end-user for connections made through a connection pool where all the sessions use the same Oracle username and show as the OS user of the webserver or application server unless that information is passed to Oracle by the application. ... The Oracle package DBMS_APPLICATION_INFO is sometimes used for this purpose. ...
    (comp.databases.oracle.misc)
  • Openquery and Oracle output parameters
    ... I am using an openquery statement to make calls to an oracle db ... and I am not sure how to capture the Oracle output parameters. ... There is an oracle package that has 4 parameters 2 in and 2 out. ...
    (microsoft.public.sqlserver)
  • Receive Email
    ... I would like to create a mail client for Oracle Forms. ... to find any Oracle package.. ... permits me to receive an email using telnet commands, ...
    (comp.databases.oracle.misc)