Home/ Questions/Resolved the problem of the ora-00984: column not allowed here
Next
Answered
Rose Schneider
  • 8
Asked: 2022-05-12T12:11:43+00:00 In:

Resolved the problem of the ora-00984: column not allowed here

  • 8

. Advertisement .

..3..

. Advertisement .

..4..

How to check – ora-00984: column not allowed here? I have the sample detail:

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
 )

While I run it, I found the warning message:

[Err] ORA-00984: column not allowed here

That is my question in my midterm exam, and it is urgent. I searched for the key on some websites, but I didn’t get it. I may miss any line or other changes. I appreciate your assistance!

column not allowed here
Share

1 Answer

  1. Best Answer
    Expert

    The cause: The string value should be surrounded by a single quotes but not double quotes. SQL uses double quotes to indicate identifiers and not string constants.

    Solution: Replacing double quotes by single ones as bellow:

    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
)
    • 24

Leave an answer

You must login to add an answer.

Need An Account,