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.

 From your SQL statement it is impossible to tell what you are doing. But since no VARCHAR2 column exceeds 4000 bytes and you are claiming to be doing:

where Instr(String1,string2) > 0

You are either looking at a CLOB or something else is not as you have presented it. That is precisely what Oracle is trying to tell you in a more cryptic manner.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)