2 Replies Latest reply on Oct 25, 2013 10:13 AM by 936666

    ORA-29471: DBMS_SQL access denied

    936666

      getting error :

      ORA-29471: DBMS_SQL access denied

       

      i am giving as

       

      DECLARE

              rc_number INTEGER;

          BEGIN

              rc_number := DBMS_SQL.OPEN_CURSOR;

      dbms_output.put_line(rc_number);         

          END;

       

      Error report:

      ORA-29471: DBMS_SQL access denied

      ORA-06512: at "SYS.DBMS_SQL", line 1017

      ORA-06512: at line 4

       

      how to find the opened cursor under SYS.DBMS_SQL and close the same.

       

      i am getting even if i open a new session and try .