Like Operator with CLOB datatype

From: bala <balkiir_at_gmail.com>
Date: 19 Nov 2006 15:21:09 -0800
Message-ID: <1163978469.676959.90690@b28g2000cwb.googlegroups.com>

Hi Gurus

Scenario
MS Access Frontend Application with Oracle 8i Backend (linked tables)

Have a Select query with the 'Like' operator on a column with CLOB datatype in the WHERE clause. It raises an error that Datatype is inconsistent.

It is there any way to make the Like operator work on a column with CLOD datatype without converting the column to Varchar2 Datatype.

Also is there any other way apart from using dbms_lob.instr? Since these linked tables Stored Procedures or any backend functions can't be used.

If using dbms_lob.instr is the only way, can you please give me an example. There can be upto three to four column of CLOB datatype in the where clause with LIKE operator with other filter conditions.

Thanx in advance

Regards
Bala Received on Sun Nov 19 2006 - 17:21:09 CST