Re: ILLEGAL USE OF LONG DATATYPE?

From: santysharma <santysharma_at_hotmail.com>
Date: Mon, 7 Jan 2002 09:47:10 -0800
Message-ID: <a1cn8l$pnchk$1@ID-84096.news.dfncis.de>

one of the restriction on use of long datatype..and there are many more, use CLOB/ LOB instead.

santysharma

"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:47:10 CST