From: davep@centurysystems.net   
      
   Thanks for responding.   
      
   Do you have an example of using a bind variable ?   
      
   Any help would be appreciated.   
   Thanks,   
   Dave   
   "mcstock"  wrote in message   
   news:NaqdnYzsEfdQqyiiRVn-uA@comcast.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)