ORA-00984: column not allowed here [duplicate]

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 ) 

Answer 1

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.