Re: Inserting Data Into Long Data Type

This can be resolved by using the SQL*Plus COPY statement.

Hth,

Sybrand Bakker, Oracle DBA

On Thu, 2 Sep 1999 13:56:55 +0700, "Kuncoro Tri Atmoko" <kuncoro_at_lintasarta.co.id> wrote:

>Dear all,
>
>I have a problem when inserting data with LONG datatype, from another table
>with long datatype too.
>Ex:
> Table A (X1 Long)
> Table B (X2 Long)
>
>I want to insert into table A from table B:
> insert into A (X1)
> select X2 from B
>
>When I do this, i've got an error message :
> ORA-00997: illegal use of LONG datatype
>
>How do I solve this problem ?
>I guess the problem will occur on RAW datatype too.
>
>Thanks.
>
>Kuncoro
>Jakarta, Indonesia
>
>
Received on Thu Sep 02 1999 - 03:44:32 CDT