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

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 - 15:55:53 CET