HELP: CLOB Invalid Data Type ??? (New to Oracle)
From: Sharron <sharron_allen_at_raytheon.com>
Date: Mon, 02 Jun 2003 14:05:40 -0700
Message-ID: <3EDBBC24.6030401_at_raytheon.com>
Date: Mon, 02 Jun 2003 14:05:40 -0700
Message-ID: <3EDBBC24.6030401_at_raytheon.com>
Hi all, I am trying to run a SQL statement:
CREATE TABLE stars_ann
(id smallint NOT 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
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);
Thanks
Sharron
Received on Mon Jun 02 2003 - 23:05:40 CEST