Re: ORA-00984 while inserting data?

From: Ms. D.H. Harvey <qq45_at_liverpool.ac.uk>
Date: 2 Oct 2003 14:36:42 GMT
Message-ID: <blhd5q$d5d$1@news.liv.ac.uk>

,Hemant Shah <shah_at_typhoon.xnet.com> 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

  1 insert into shahtst (KEY0, KEY1) values   2* ('12345678901234', '12345678901234567890123456')

1 row created.

no_name> select * from shahtst;

KEY0 KEY1

-------------- --------------------------

12345678901234 12345678901234567890123456

HTH Helen

: --
: 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:36:42 CDT