PL/SQL (MOSC)

MOSC Banner

Stored procedure to update rows and return in result set

edited Mar 24, 2014 4:04PM in PL/SQL (MOSC) 6 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center