Stored procedure to update rows and return in result set
I am wanting to write a stored procedure that will update rows and return the same rows as a result set. Here is a possible solution. However, it seems like there is a possiblilty that different rows may be returned than those updated if other activity on the table occurs between the select and update. Is there a way to use the recordset as input to an update so I can insure the same rows are updated? Or, is there a better way. Thanks, Gary
create or replace
PROCEDURE UPD_MY_SUFF
( I_DATE IN DATE
, O_ERR_NUM OUT NUMBER