Search notes:

ORA-29471: DBMS_SQL access denied

declare
   cur  integer;
begin
   cur := dbms_sql.open_cursor;
  
   dbms_sql.close_cursor(cur);
   dbms_sql.close_cursor(cur);
end;
/
Cursor is not opened:
declare
   c    number;
   stmt varchar2(1000);
begin
   dbms_sql.parse(c, stmt, dbms_sql.native);
end;
/

See also

dbms_sql
Other Oracle error messages
MOS Note 760560.1
The following statement is supposed to turn of security features in dbms_sql:
alter system set "_dbms_sql_security_level" = 384 scope=spfile;

Index