Re: ref cursors

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Thu, 03 May 2001 23:42:13 -0700
Message-ID: <3AF24F45.AB35270@exesolutions.com>

rrodriguez_at_csi.uned.es wrote:

> Hi,
> I have a package with a generic ref cursor, inside this package i have
> several procedures that call that cursor.
> My problem is that in an ASP page i can see an error "01000 - Too open
> cursors exceed." but in each procedure i execute one select that is
> returned by that procedure.
> My OPEN_CURSOR variable is set to 20.
> Questions: Why oracle not release the cursor? How can i release this
> variable(cursor)?
>
> Thanks in advance...

Have you considered closing it?

Daniel A. Morgan Received on Fri May 04 2001 - 01:42:13 CDT