From: ken@kendenny.com   
      
   sven_horn@web.de (Sven) wrote in   
   news:4fbac945.0312100705.1b24037a@posting.google.com:   
      
   > i try to write a PL/SQL procedure for Oracle 9.2   
   >   
   > is there a way to retrieve the number of affected rows of an INSERT or   
   > an UPDATE statement?   
   > i tried different ways with RETURNING INTO... but its not working :(   
   >   
   > my statement is like:   
   >   
   > insert into BEP_EQUIPMENT_CACHE   
   > (select * from BEP_EQUIPMENT_MV WHERE EQUIPMENT not in (SELECT   
   > EQUIPMENT FROM BEP_EQUIPMENT_CACHE));   
   >   
   > please help,   
   > thank you all - sven   
   >   
      
   Take a look at SQL%ROWCOUNT   
      
   --   
   Ken Denny   
   http://www.kendenny.com/   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)