Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Number of rows updated
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