Hi there,

I'm trying to run a script which creates sample schemas for an Oracle Developer 6 course, it's running on a Sun Solaris box on an Oracle 9i database.

It seems to be sticking at the following create statement.

CREATE TABLE online_media
( product_id NUMBER(6)
, product_photo ORDSYS.ORDImage
, product_photo_signature ORDSYS.ORDImageSignature
, product_thumbnail ORDSYS.ORDImage
, product_video ORDSYS.ORDVideo
, product_audio ORDSYS.ORDAudio
, product_text CLOB
, product_testimonials ORDSYS.ORDDoc
) ;

ORA-00902 invalid data type.

Can anyone help

Thanks in advance