Re: SQL and Long

"Fons Reijsbergen" <fons.reijsbergen_at_kb.nl> wrote in message news:<9osmb1$d5m$1_at_news.surfnet.nl>...
> Hello,
>
> I have a small problem. I have created the next table
>
> CREATE TABLE FICHESGMLS
> (FICHEID CHAR(12) NOT NULL,
> SGML LONG NOT NULL,
> PRIMARY KEY (FICHEID));
>
> I have the next query:
>
> Select * from FICHESGMLS where SGML like '%rome%';
> I get the error: ORA-00932: Inconsistent datatypes.
> or
> Select * from FICHESGMLS where SGML = 'Rome';
> the error: ORA-00997: Illegal use of LONG datatype.
>
> does this mean that I can not search in the Long datafield?
> And if so what must I do to do the job.
>
>
> Thanks in advance
> Fons Reijsbergen
>
> fons.reijsbergen_at_kb.nl

I don't know what version of Oracle you're using. In Oracle 8.x, you can create LOB (Large OBject) datatypes such as BLOB, CLOB, BFILE or NCLOB datatypes. Manipultion of LOBs can be done using DBMS_LOB package. Hope it helps. Received on Thu Sep 27 2001 - 12:39:30 CEST