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;
/

See also

dbms_sql
Other Oracle error messages

Index