From: frank.van.bortel@gmail.com   
      
   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...   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)