Re: ORA-00984 while inserting data?

From: Spark <markfle_at_yahoo.com>
Date: Thu, 2 Oct 2003 15:24:56 +0100
Message-ID: <3f7c3539$0$252$ed9e5944@reading.news.pipex.net>

"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
>

SNIP Try

SQL> insert into shahtst values ('12345678901234', '12345678901234567890123456');

1 row created.

HTH Mark F Received on Thu Oct 02 2003 - 09:24:56 CDT