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

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 Mon Jun 02 2003 - 23:05:40 CEST