ORA-00984: column not allowed here

ORA-00984: column not allowed here

Oracle PL/SQL error message: ORA-00984: column not allowed here.

Cause:

A column name was used in an expression where it is not permitted, such as in the VALUES clause of an INSERT statement.

Solution:

Check the syntax of the statement and use column names only where appropriate.




Example:

CREATE TABLE TEST3(
ID NUMBER NOT NULL, 
NAME VARCHAR2(250)
);

INSERT INTO TEST3(ID,NAME) VALUES (5,"123");

Output:

ORA-00984: column not allowed here

Correct:

INSERT INTO TEST3(ID,NAME) VALUES (5,'123');

Output:

1 rows inserted.