SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-29474 error

Martin RidgwayApr 18 2016 — edited Apr 18 2016

I've added the parameter of value 0 (zero) in the following line

cursor_handle INTEGER := dbms_sql.open_cursor(0);

to get around the ORA-29471 error (ORA-29471: DBMS_SQL access denied) further on in the procedure.

Now I get ORA-29474 error (ORA-29474: DBMS_SQL.OPEN_CURSOR failed. security_level of 0 is not allowed) on that line.

The Oracle documentation plainly says that 0 is OK.

So what's missing/wrong?

(11.2.0.4.0 enterprise)

Locked Post

New comments cannot be posted to this locked post.

Locked on May 16 2016

Added on Apr 18 2016

7 comments

612 views