Re: HELP: CLOB Invalid Data Type ??? (New to Oracle)
From: Sharron <sharron_allen_at_raytheon.com>
Date: Mon, 02 Jun 2003 17:00:35 -0700
Message-ID: <3EDBE523.6000807_at_raytheon.com>
Date: Mon, 02 Jun 2003 17:00:35 -0700
Message-ID: <3EDBE523.6000807_at_raytheon.com>
Answered my own question the LONG datatype works fine!
Sharron wrote:
> Hi all, I am trying to run a SQL statement:
>
> CREATE TABLE stars_ann
> (id smallint NOT NULL,
> author varchar2(255) default NULL,
> subject varchar2(255) default NULL,
> message CLOB,
> staff char(1) default NULL,
> users char(1) default NULL,
> time varchar2(16) default NULL);
>
> but I get the error message ORA-00902: invalid datatype
> everytime I add the CLOB datatype to the statement above. I looked
> everywhere and this should be right. I tried using varchar2(2000) but
> its just not big enough. Im new to Oracle and Im at a total lost. Please
> help.
>
> Thanks
> Sharron
>
Received on Tue Jun 03 2003 - 02:00:35 CEST