It isn't that they got rid of it; this is a limitation that they have had
since day 1. You can't do an insert as select with a long.
Jim
"Jay Valdez" <jay_at_dontspamme.com> wrote in message
news:8al_7.1815$N9.4191_at_news.bc.tac.net...
>
> 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 - 20:42:32 CST
