SyntaxFix

[oracle] ORA-00984: column not allowed here

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.

Examples related to oracle

• concat yesterdays date with a specific time • ORA-28001: The password has expired • how to modify the size of a column • How to create a blank/empty column with SELECT query in oracle? • Find the number of employees in each department - SQL Oracle • Query to display all tablespaces in a database and datafiles • When or Why to use a "SET DEFINE OFF" in Oracle Database • How to insert date values into table • error: ORA-65096: invalid common user or role name in oracle • In Oracle SQL: How do you insert the current date + time into a table?

Examples related to oracle10g

• Query to display all tablespaces in a database and datafiles • How to insert date values into table • Why do I get PLS-00302: component must be declared when it exists? • ORA-28000: the account is locked error getting frequently • Oracle Trigger ORA-04098: trigger is invalid and failed re-validation • Inserting Image Into BLOB Oracle 10g • Error System.Data.OracleClient requires Oracle client software version 8.1.7 or greater when installs setup • Different CURRENT_TIMESTAMP and SYSDATE in oracle • Search for a particular string in Oracle clob column • ORA-00984: column not allowed here