PL/SQL (MOSC)

MOSC Banner

executing DBMS_SQL

edited Oct 21, 2009 10:50PM in PL/SQL (MOSC) 9 commentsAnswered
I am executing the following code-snippet:

    DBMS_SQL.PARSE (L_CUR,
                L_SQL_TABLE,
                L_SQL_TABLE.FIRST,
                L_SQL_TABLE.LAST,
                FALSE,
                DBMS_SQL.NATIVE);

and I am getting the following error:   Error: ORA-01031: insufficient privileges  [ -1031]

The user executing has execute privs on DBMS_SQL & DBA-privs

Can anybody help?

THX in advance.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center