INSTR and string length problem

From: Ashley Morgan <amorgan_at_onet.co.uk>
Date: Mon, 14 Nov 2005 15:50:07 -0000
Message-ID: <4378b22e$0$63096$ed2e19e4@ptn-nntp-reader04.plus.net>

Hi,

I wonder if anybody can help. I have a where clause which looks for a string pattern e.g.

Select * from Table where Instr(String1,string2) > 0

When String1 is less than 4000 characters the query works, when this is increased to 6000 characters, I get the error message "ORA-01460: unimplemented or unreasonable conversion requested".

Can somebody please explain why this is happening and how I can resolve it ?

Thanks in Advance. Received on Mon Nov 14 2005 - 09:50:07 CST