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

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);

SQL>
SQL> drop table stars_ann
  2 /

Table dropped.

SQL> Received on Tue Jun 03 2003 - 14:58:27 CEST