Good morning! I have a stored procedure where I am selecting records with a status of '0'. Once the stored procecedure has selected the records with '0' status, I now have to change the status to '1' (processed).
Now, I know that if I use "where current of myCursor" for the UPDATE command, they will not get updated because they are locked by the cursor. On the other hand, if I just say UPDATE status to '1' where "status = '0'" it will update the records, but they will no longer be returned in the result set because the status is no longer '0'.
Is there a way of getting around this? Perhaps calling another stored procedure, or submitting something to update the status?