Using LOBs in SQLPLUS

Hey Gang.

I have a table with a CLOB in it. I'd like to know which rows include a certain string. Unfortunately, this doesn't work:

select * from aTable where theClob like '%X%';

I get an "ORA-00932: inconsistent datatypes" error. I'm using Oracle 8.5 on a Linux server.

Thanks for any help!

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Dec 02 1999 - 00:09:09 CST