From: fbortel@nescape.net   
      
   Dave Pylatuk wrote:   
      
   > 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.   
   >>|   
   >>|   
   >>|   
   >>   
   >>   
   >   
   >   
   >   
   insert into bla (a, b, c) values (:x, :y, :z);   
   :x, :y and :z are the bind variables.   
      
   Yuou would use it in a statement like:   
      
   begin   
      for i in 1..100    -- or a select statement   
        execute immediate   
         'insert into bla (a, b, c) values (:x, :y, :z)'   
          using a_variable, another_variable, yet_another;   
       end loop;   
   end;   
      
   --   
   Regards, Frank van Bortel   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)