From: kennedy-downwithspammersfamily@attbi.net   
      
   "Markus Breuer"  wrote in message   
   news:3F8D36EF.4090309@gmx.de...   
   > Instead of using a set of different sql-statements i have decided to use   
   > an single, anonymous pl/sql block with host-variables. For example:   
   >   
   > DECLARE   
   >   cmp   NUMBER := :hostvariable;   
   > BEGIN   
   >     UPDATE t_sample SET c_id=0 WHERE tid>cmp;   
   > END;   
   >   
   > Are there any disadvantages concerning simle update-statement?   
   > Won't oracle cache such blocks, do they need more processing time or   
   > more cpu-power on the server? Or does oracle treat them as any other   
   > sql statement?   
   >   
   > thx, markus   
   >   
   >   
   The fastest way would be a straight insert with a host variable, keep the   
   cursor around, rebind and reexecute. If you were inserting a lot of rows at   
   a time then use the array interface to blast them in 100 or more rows at a   
   time.   
   Jim   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)