Ora-00984: Column Not Allowed Here [Duplicate]

Name: Ora-00984: Column Not Allowed Here [Duplicate]
Uploaded: 2026-10-05T13:19:18+00:00
Duration: 17 min 34 s
Description: I Am Doing a Simple Oracle Insert and I Keep Getting This Error: [Err] Ora-00984: Column Not Allowed Here Insert into My. Logfile (Id, Severity, Category...

Question

I am doing a simple Oracle INSERT and I keep getting this error: [Err] ORA-00984: column not allowed here

INSERT INTO MY.LOGFILE
(id,severity,category,logdate,appendername,message,extrainfo)
VALUES
(
"dee205e29ec34",
"FATAL",
"facade.uploader.model",
"2013-06-11 17:16:31",
"LOGDB",
NULL,
NULL
)

Accepted Answer

Replace double quotes with single ones:

INSERT
INTO    MY.LOGFILE
        (id,severity,category,logdate,appendername,message,extrainfo)
VALUES  (
       'dee205e29ec34',
       'FATAL',
       'facade.uploader.model',
       '2013-06-11 17:16:31',
       'LOGDB',
       NULL,
       NULL
       )

In SQL, double quotes are used to mark identifiers, not string constants.

Ora-00984: Column Not Allowed Here [Duplicate]

Must Read

1 Answer

David Miller