I've been studying how to get results from an Oracle
stored procedure. There is documentation on doing this.
You basically return a REF CURSOR from an Oracle package
and access that in your application.
I have a question though: is there any need to explicitly
close the REF CURSOR? When returning the cursor from the
stored procedure, you just open it and return it. Then,
you access the data in .NET. I never go about actually
closing it, and I'm not sure if this will cause any
problems.
Anybody know? Thanks.
stored procedure. There is documentation on doing this.
You basically return a REF CURSOR from an Oracle package
and access that in your application.
I have a question though: is there any need to explicitly
close the REF CURSOR? When returning the cursor from the
stored procedure, you just open it and return it. Then,
you access the data in .NET. I never go about actually
closing it, and I'm not sure if this will cause any
problems.
Anybody know? Thanks.