From: fvanbortel@netscape.net   
      
   Fred wrote:   
   > Hi all,   
   >   
   > I have a nice problem. I´m trying to convert a Long to varchar2. It   
   > works when the long field doesn´t contain more than 2000 characters.   
   > How do I solve this?   
   >   
   > I´m working with Oracle 7 by the way.   
   >   
   > /Fred   
      
   SQL or PL/SQL?   
   SQL: try "set long "   
   PL/SQL: a varchar variable holds 4k/32k max, so you   
   are stuck. 32k when you just want to use it, 4k when   
   you want to interface with it (e.g. store in a table)   
      
   --   
      
   Regards,   
   Frank van Bortel   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)