D
devchick25
Hi,
I'm creating a .NET service using an Oracle backend. We
would prefer executing our select statements within a
stored procedure. One of our select statement will return
0, 1, or many records.
Is it possible to return a resultset from Oracle to .NET
using an Oracle ref cursor? It's my understanding that a
ref cursor must be declared as part of a package. The
package should also have a proc that references that ref
cursor.
Can someone explain how to return/call the stored
procedure/package from .NET and return a resultset. As
mentioned, the proc. in the package would need to use a
ref cursor (I believe).
Any insight would be appreciated.
Thanks!
I'm creating a .NET service using an Oracle backend. We
would prefer executing our select statements within a
stored procedure. One of our select statement will return
0, 1, or many records.
Is it possible to return a resultset from Oracle to .NET
using an Oracle ref cursor? It's my understanding that a
ref cursor must be declared as part of a package. The
package should also have a proc that references that ref
cursor.
Can someone explain how to return/call the stored
procedure/package from .NET and return a resultset. As
mentioned, the proc. in the package would need to use a
ref cursor (I believe).
Any insight would be appreciated.
Thanks!