Re: Fail to copy a LONG datatype in Oracle to another table

From: Etienne Gauthier <egauthie_at_capgemini.fr.nospam>
Date: Mon, 13 Dec 1999 15:55:53 +0100
Message-ID: <385508F9.103A0BFE@capgemini.fr>

Rich Tsui wrote:
>
> Hi Oracle gurus,
>
> I have trouble in copying a LONG datatype column of data to another
> table via
> "INSERT INTO tableA (A_col_NUM, A_col_LONG)
> SELECT B_col_NUM, B_col_LONG FROM tableB", where the A_col_LONG and
> B_col_LONG represent the LONG datatype.
>
> The error message I got from the sqlplus is:
> ORA-00997: illegal use of LONG datatype
>

Read the Oracle Doc. AFAIK, you can't use LONG datatype in sub queries. Here, you'll have to do a loop yourself.

Etienne Received on Mon Dec 13 1999 - 08:55:53 CST