Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00984: column not allowed here ??
ORA-00984: column not allowed here ?? [message #229841] Tue, 10 April 2007 02:50 Go to next message
websmythe
Messages: 10
Registered: March 2007
Junior Member
I'm a little lost. Could someone shed some light on this for me?? Thanx.

-- CHK_QUESTIONS / Table Structure
-- Column Name  Data Type     Nullable    Default   Primary Key
-- -------------------------------------------------------------
-- CHK_ID	NUMBER(10,0)	Yes          -          -
-- CHK_QNO	NUMBER(10,0)	Yes          -          -
-- CHK_QMASK	VARCHAR2(27)	Yes          -          -
-- CHK_QTEXT	VARCHAR2(72)	Yes          -          -


INSERT INTO CHK_QUESTIONS ( CHK_ID, CHK_QNO, CHK_QMASK, CHK_QTEXT )
VALUES (1, 1, "MM-DD-RR", "Start Date")


-- ERROR MESSAGE
-- ----------------------------------
-- ORA-00984: column not allowed here
Re: ORA-00984: column not allowed here ?? [message #229847 is a reply to message #229841] Tue, 10 April 2007 02:57 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,

Use Single Quotes Instead of Double quotes.

regards
Taj
Re: ORA-00984: column not allowed here ?? [message #229848 is a reply to message #229841] Tue, 10 April 2007 02:58 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Use single quotes, not double ones.
Re: ORA-00984: column not allowed here ?? [message #230014 is a reply to message #229841] Tue, 10 April 2007 09:38 Go to previous message
websmythe
Messages: 10
Registered: March 2007
Junior Member
Duh!
Nothing like the obvious is there?
Embarassed
Thanx folks.
Previous Topic: Trigger problem
Next Topic: Tracking PL/SQL Code Changes
Goto Forum:
  


Current Time: Wed Dec 07 14:41:03 CST 2016

Total time taken to generate the page: 0.11053 seconds