Re: INSTR and string length problem

Ashley Morgan wrote:
> 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.
>
>

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