ORA-00984: column not allowed here [message #224630] |
Wed, 14 March 2007 19:08  |
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?
|
|
|
|