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:[color=blue]
> 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.
>
>[/color]

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...