Re: Please help with long data type

From: Silvia Ehlers <sehlers_at_debis.com>
Date: Thu, 14 Jan 1999 13:28:00 +0100
Message-ID: <369DE2D0.44350CD0@debis.com>

Write a cursor for the select statement. Then do the inserts in a cursor loop.

Silvia

Pornpira Vachareeyanukul wrote:
>
> Hi
> I'm trying to insert long data type from another long data type
> using the following:
>
> Table chk_segment
> chk_segment long
>
> Insert into chk_segment
> Select chk_segment_name
> from chk_segment
> where #######
>
> I've got an error
> ORA-00997: illegal use of LONG datatype.
>
> Please help.
> Thank you in advance.
> Mimi
Received on Thu Jan 14 1999 - 06:28:00 CST