ORA-984 ORA-6512 ORA-4088 When Using DBMS_SQL (Doc ID 1054105.6)

Last updated on JULY 17, 2017

Applies to:

PL/SQL - Version 8.0.6.0 and later
Information in this document applies to any platform.

Symptoms

 The DBMS_SQL package returns the following errors, pointing the dbms_sql.parse() statement:

    ERROR at line 1:
    ORA-00984: column not allowed here
    ORA-06512: at "SYS.DBMS_SYS_SQL", line 239
    ORA-06512: at "SYS.DBMS_SQL", line 32
    ORA-06512: at "NLIU.W", line 15
    ORA-04088: error during execution of trigger 'NLIU.W'

For example, the following script generates the errors:

 
ERROR at line 1:
ORA-00984: column not allowed here
ORA-06512: at "SYS.DBMS_SYS_SQL", line 239

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms