INSTR and string length problem

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.

re: INSTR and string length problem

Ashley Morgan wrote:SQL Reference manual, Oracle Data Types:
look up the restrictions on varchar2.

And this ng is dead - post in cdo.server, or cdo misc

--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...