INSTR and string length problem

[Ashley Morgan]

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,s tring2) 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.

[Frank van Bortel]

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,s tring2) 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...