Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Please help with long data type

Please help with long data type

From: Pornpira Vachareeyanukul <pornpira_at_beta.tricity.wsu.edu>
Date: Tue, 12 Jan 1999 14:05:27 -0800
Message-ID: <Pine.OSF.3.96.990112135628.14478B-100000@beta.tricity.wsu.edu>


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 Tue Jan 12 1999 - 16:05:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US