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