From: mcstockspamplug@spamdamenquery.com   
      
   according to the error message manual:   
      
   ORA-01704 string literal too long   
   Cause: The string literal is longer than 4000 characters.   
   Action: Use a string literal of at most 4000 characters. Longer values may   
   only be entered using bind variables.   
      
   make sure you get yourself a copy for future reference ;-)   
      
   -- mcs   
      
   "Dave Pylatuk"  wrote in message   
   news:U9atb.45866$xI2.1106301@news20.bellglobal.com...   
   | Hello, I am getting the above error when executing a large insert   
   statement   
   | against 8.1.7.   
   |   
   | This insert statement includes a very large string value, about 8000   
   | characters long. Is there a limit on the size of statements that Oracle   
   | can execute ?   
   |   
   | Is this a setting that can be changed ?   
   |   
   | Thanks in advance.   
   |   
   |   
   |   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)