ORA-00984 while inserting data?

From: Hemant Shah <shah_at_typhoon.xnet.com>
Date: Thu, 2 Oct 2003 14:00:47 +0000 (UTC)
Message-ID: <blhb2f$jvo$1@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.

Received on Thu Oct 02 2003 - 09:00:47 CDT