Re: ORA-00997: illegal use of LONG datatype

From: Dante <dnotari_at_my-deja.com>
Date: Tue, 08 Jun 1999 12:50:17 GMT
Message-ID: <7jj3i5$ju8$1@nnrp1.deja.com>

Dimitri,
yep ... that is one of the many restrictions for LONGs. You can't use them in selects ;-)

My recommendation is to use LOBs (BLOB, CLOB) instead.

Regards
Dante

In article <7jiune$67a$1_at_srv4-poa.nutecnet.com.br>, "Dimitri R. de Souza" <dimitrir_at_zaz.com.br> wrote:
> Hi!
>
> I'm trying to copy some rows of one table to other with exactly the
same
> strutcture with the command "INSERT INTO <table1> SELECT * FROM
<table2>",
> but I'm having some troubles: if the table has any field of
type "LONG RAW",
> when the command is executed, the Oracle returns the error "ORA-00997:
> illegal use of LONG datatype".
>
> Any help or ideia? I'm using Oracle 8.0.4....
>
> Thanks,
>
> Dimitri
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jun 08 1999 - 07:50:17 CDT