Home -> Usenet -> comp.databases.oracle -> INSTR and string length problem

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_at_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 - 16:50:07 CET












Original text of this message