"Hemant Shah" <shah_at_typhoon.xnet.com> wrote in message
news:blhb2f$jvo$1_at_flood.xnet.com...
>
> Folks,
>
> I am getting ORA-00984 while inserting data into the table. What am i
doing
> wrong:
>
>
> SQL> create table shahtst
> 2 (KEY0 CHAR (14), KEY1 CHAR (26 ))
> 3 TABLESPACE HARTTST1_DATA02
> 4 PCTFREE 10 PCTUSED 70
> 5 INITRANS 1 MAXTRANS 255
> 6 LOGGING;
>
> Table created.
>
> SQL> describe shahtst
> Name Null? Type
> ----------------------------------------- -------- ----------------------
> KEY0 CHAR(14)
> KEY1 CHAR(26)
>
>
>
> SQL> insert into shahtst (KEY0, KEY1) values
> 2 ("12345678901234", "12345678901234567890123456");
> ("12345678901234", "12345678901234567890123456")
> *
> ERROR at line 2:
> ORA-00984: column not allowed here
>
>
>
>
>
>
> --
> Hemant Shah /"\ ASCII ribbon campaign
> E-mail: NoJunkMailshah_at_xnet.com \ / ---------------------
> X against HTML mail
> TO REPLY, REMOVE NoJunkMail / \ and postings
> FROM MY E-MAIL ADDRESS.
> -----------------[DO NOT SEND UNSOLICITED BULK E-MAIL]------------------
> I haven't lost my mind, Above opinions are mine only.
> it's backed up on tape somewhere. Others can have their own.
Use ' not " . Also you should probably use varchar2 not char or use number.
(not sure if the key is numeric or character, if it is a set of numbers use
number.)
Jim
Received on Thu Oct 02 2003 - 09:19:11 CDT
