Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Number of rows updated

Number of rows updated

From: <tunity5_at_yahoo.com>
Date: 15 Feb 2006 19:42:30 -0800
Message-ID: <1140061350.728038.320560@z14g2000cwz.googlegroups.com>


I have a block of statements like the following. The last statement in the block is an update statement. I was wondering if there is a way to get the number of rows updated by that statement. An easy way would be to wrap the whole thing in a function but, the code is not mine and it is difficult to change "legacy" code with the current managers:

DECLARE var_a number;

       var_b number;
BEGIN

      a bunch of sql statement go here;
      update emp_table set bonus = new_rate where dept_num = 'abc';
END; Received on Wed Feb 15 2006 - 21:42:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US