Re: HELP: CLOB Invalid Data Type ??? (New to Oracle)
From: Sharron <sharron_allen_at_raytheon.com>
Date: Fri, 06 Jun 2003 15:38:36 -0700
Message-ID: <3EE117EC.4060100_at_raytheon.com>
Date: Fri, 06 Jun 2003 15:38:36 -0700
Message-ID: <3EE117EC.4060100_at_raytheon.com>
Im using Oracle 8i....someone else says that LONG is deprecated....if I can't use LONG or CLOB what can I use in 8i ?
DM wrote:
> Your script is right..
> I just did the copy paste, it works fine...
> what version of oracle you are using? It works find on Oracle 9
>
> Connected.
> SQL> CREATE TABLE stars_ann
> 2 (id smallint NOT NULL,
> 3 author varchar2(255) default NULL,
> 4 subject varchar2(255) default NULL,
> 5 message CLOB,
> 6 staff char(1) default NULL,
> 7 users char(1) default NULL,
> 8 time varchar2(16) default NULL);
>
> Table created.
>
> SQL>
> SQL> drop table stars_ann
> 2 /
>
> Table dropped.
>
> SQL>
Received on Sat Jun 07 2003 - 00:38:36 CEST