LONG datatype is depreciated - you should look into CLOBs instead of LONGs.
"Jay Valdez" <jay_at_dontspamme.com> wrote in message
news:5Ik_7.1814$N9.4277_at_news.bc.tac.net...
> INSERT INTO TRAININGPROGRAMS_TEST SELECT * FROM TRAININGPROGRAMS
>
> Error-->ILLEGAL USE OF LONG DATATYPE.
>
> Oracle 8.1.7
>
> Hello, I was wondering why this would occur in this situation.
>
> This is the DDL
>
> CREATE TABLE TRAININGPROGRAMS (
> TYPEID NUMBER NOT NULL,
> PROGRAMNAME VARCHAR2 (255),
> DESCRIPTION LONG,
> TIMEINDEX DATE DEFAULT SYSDATE,
> PRIMARY KEY ( TYPEID ) ) ;
>
> CREATE TABLE TRAININGPROGRAMS_TEST (
> TYPEID NUMBER NOT NULL,
> PROGRAMNAME VARCHAR2 (255),
> DESCRIPTION LONG,
> TIMEINDEX DATE DEFAULT SYSDATE,
> PRIMARY KEY ( TYPEID ) ) ;
>
>
Received on Mon Jan 07 2002 - 11:31:38 CST
