Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-00984 while inserting data?

Re: ORA-00984 while inserting data?

From: Hemant Shah <shah_at_typhoon.xnet.com>
Date: Thu, 2 Oct 2003 19:20:54 +0000 (UTC)
Message-ID: <blhtqm$qa9$1@flood.xnet.com>

Thanks to all who replied, I user ' and it worked.

While stranded on information super highway Hemant Shah wrote:
:)
:)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.

-- 
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 - 14:20:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US