Re: ORA-00997: illegal use of LONG datatype

From: Dimitri R. de Souza <dimitrir_at_zaz.com.br>
Date: Tue, 8 Jun 1999 12:40:00 -0300
Message-ID: <7jjdgr$j2a$1@srv4-poa.nutecnet.com.br>

Dante,

Yes, this is the solution I found (BLOB and CLOB also add support to transactions - LONG RAW doesn't...). But I'll have to write an specific program to convert the data, and this is what I am trying to avoid. I have a large database of pictures stored in a LONG RAW column, and the job will not be easy... Anyway, I think this is the only way - you just confirmed my suspects... :-(

Thanks,

Dimitri

> 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
Received on Tue Jun 08 1999 - 10:40:00 CDT