Re: MAXIMUM CURSORS EXCEEDED !!!

A copy of this was sent to "Meinaz" <meinaz_at_cyberway.com.sg> (if that email address didn't require changing) On 11 Jun 99 16:51:39 GMT, you wrote:

>Hi folks,
>
>I have wriiten a PL/SQL script that gets the nextval from a user-created
>sequence. The select SEQ.nextval statement is parse dynamically by using
>DBMS_SQL package.
>
>The problem is I am unable to run this script too many times. I'll hit
>"MAXIMUM CURSOR EXCEEDED" SQL error. Can someone tell me where have i gone
>wrong with my script? Did I miss out anything. I DO close the cursor
>though.
>
>When i check v_$open _cursor, the sql_text corresponding to the cursor are
>the select from sequence statement.
>Is v_$open_cursor the CORRECT views to check for any currently opened
>cursors in the database instance?
>
>BTW, I am using ORACLE 7.2.3.
>
>Appreciate ANY advice!!
>
>THANX!!
>
>meinaz

lets see the script

See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'... Mirrored (and more current) at http://govt.us.oracle.com/~tkyte/

Current article is "Fine Grained Access Control", added June 8'th  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

-- 
Opinions are mine and do not necessarily reflect those of Oracle Corporation