Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: InStr and Length Problem Ora-01460
Ashley Morgan wrote:
> 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". I have checked the
> reference data and it says that a string up 32767 charcaters can be handled
> in Pl/SQL.
>
> Can somebody please explain why this is happening and how I can resolve it ?
>
> Thanks in Advance.
>
>
I already explained you should read the Reference Manual in cd.oracle.
Did you see the bit where it listed restrictions on varchar2?
-- Regards, Frank van Bortel Top-posting is one way to shut me up...Received on Tue Nov 15 2005 - 12:34:23 CST
![]() |
![]() |