Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00984: column not allowed here
ORA-00984: column not allowed here [message #224630] Wed, 14 March 2007 19:08 Go to next message
xZEXx
Messages: 1
Registered: March 2007
Location: Canada
Junior Member

Hello all,

I created a table called "player" and is described below

Name Null? Type
----------------------------------------- -------- ----------------------------
PLAYERNAME NOT NULL VARCHAR2(20)
SALARY NUMBER(38)
POSITION VARCHAR2(20)
TOTALSCORE NUMBER(38)
TEAMNAME VARCHAR2(20)


i try to run this insert statement

insert into player(playerName,salary,position,totalscore,teamname)
values("Elliot","50000","Center","4564","CalgaryFlames");

and i receive "ORA-00984: column not allowed here" with a nice litter * right under the column TEAMNAME. I'm not sure what to do. I'll eliminate any columns other then the primary key column and i will still receive the same message. I'll try just to insert into without defining the columns for entry with all the date needed and the same will occur. Can someone help me?
Re: ORA-00984: column not allowed here [message #224631 is a reply to message #224630] Wed, 14 March 2007 19:22 Go to previous message
jdufour
Messages: 4
Registered: March 2007
Junior Member
Use single quotes around strings and no quotes around numbers.
insert into xxx(playerName,salary,position,totalscore,teamname)
values('Elliot',50000,'Center',4564,'CalgaryFlames');
Previous Topic: Role of ETL Tool - OWB
Next Topic: 2 Dimensional Arrays into PL/SQL
Goto Forum:
  


Current Time: Sat Dec 10 11:04:13 CST 2016

Total time taken to generate the page: 0.10274 seconds