Re: ILLEGAL USE OF LONG DATATYPE?

Ah, probably explains why they got rid of it.

Jay

"koert54" <koert54_at_nospam.com> wrote in message news:_Xk_7.11125$BZ2.2415804610_at_hebe.telenet-ops.be...
> 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:42:44 CST