SQL and Long
From: Fons Reijsbergen <fons.reijsbergen_at_kb.nl>
Date: Wed, 26 Sep 2001 15:45:25 +0200
Message-ID: <9osmb1$d5m$1_at_news.surfnet.nl>
Date: Wed, 26 Sep 2001 15:45:25 +0200
Message-ID: <9osmb1$d5m$1_at_news.surfnet.nl>
Hello,
I have a small problem. I have created the next table
CREATE TABLE FICHESGMLS
I have the next query:
Select * from FICHESGMLS where SGML like '%rome%';
I get the error: ORA-00932: Inconsistent datatypes.
or
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
(FICHEID CHAR(12) NOT NULL,
SGML LONG NOT NULL,
PRIMARY KEY (FICHEID));
Select * from FICHESGMLS where SGML = 'Rome';
the error: ORA-00997: Illegal use of LONG datatype.
Fons Reijsbergen
fons.reijsbergen_at_kb.nl Received on Wed Sep 26 2001 - 15:45:25 CEST