Home » SQL & PL/SQL » SQL & PL/SQL » Need help (again) with " ORA-00984: column not allowed here"
Need help (again) with " ORA-00984: column not allowed here" [message #364282] Sun, 07 December 2008 18:29 Go to next message
DrBallard
Messages: 20
Registered: October 2008
Junior Member
Hello again!
This time we have a problem with inserting values and we really can't find what's wrong!
The table was created as such
CREATE TABLE PASSAGER
(NO_PERSONNE INTEGER,
NO_PASSAGER INTEGER NOT NULL,
NO_PASSEPORT INTEGER NOT NULL,
NATIONALITE VARCHAR2(30) NOT NULL,
LIEU_EMISSION VARCHAR2(30) NOT NULL,
DATE_EMISSION DATE NOT NULL,
NO_TEL INTEGER,
NO_CC INTEGER,
NO_VENTE INTEGER NOT NULL,
CONSTRAINT PK_PASSAGER PRIMARY KEY (NO_PERSONNE),
CONSTRAINT FK_PASSAGER_PERSONNE FOREIGN KEY (NO_PERSONNE) REFERENCES PERSONNE (NO_PERSONNE),
CONSTRAINT FK_PASSAGER_VENTE FOREIGN KEY (NO_VENTE) REFERENCES VENTE (NO_VENTE));

for inserting the values, we did...
INSERT INTO PASSAGER VALUES (500,NOPASS_SEQ.NEXTVAL, WT456789,'CANADIENNE', 'CANADA', to_date('2007/10/12','YYYY/MM/DD'),5142348756,5157981500126734,1);


but it won't work, it's our last table and all the other worked perfectly!
Thanks a ton!
Re: Need help (again) with " ORA-00984: column not allowed here" [message #364284 is a reply to message #364282] Sun, 07 December 2008 19:29 Go to previous messageGo to next message
DrBallard
Messages: 20
Registered: October 2008
Junior Member
Found the error! Topic closed.
Re: Need help (again) with " ORA-00984: column not allowed here" [message #364335 is a reply to message #364284] Mon, 08 December 2008 00:51 Go to previous message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe for topic is closed but before starting a new one, read OraFAQ Forum Guide and

1/
Indent the code (See SQL Formatter) and use code tags.
Make sure that lines of code do not exceed 80 characters when you format.
Use the "Preview Message" button to verify.

2/
Use SQL*Plus and copy and paste your session.

3/
Also always post your Oracle version (4 decimals).

Regards
Michel

[Updated on: Mon, 08 December 2008 00:51]

Report message to a moderator

Previous Topic: order and group by
Next Topic: invoke SQL Loader
Goto Forum:
  


Current Time: Wed Dec 07 12:21:50 CST 2016

Total time taken to generate the page: 0.08293 seconds