Re: HELP: CLOB Invalid Data Type ??? (New to Oracle)

There should be an example in the docs. Don't use long it is deprecated. Jim

-- 
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family.  Remove the negative part, keep the minus sign.  You can figure
it out.
"Sharron" <sharron_allen_at_raytheon.com> wrote in message
news: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

> >

>