ref cursors

From: <rrodriguez_at_csi.uned.es>
Date: Thu, 03 May 2001 11:12:50 GMT
Message-ID: <3af13937.16766238@news.uned.es>

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... Received on Thu May 03 2001 - 06:12:50 CDT