The social network for Oracle people
After an Update statement, Sql%NotFound is being validated. Sql%NotFound validates to true even though a record matching the update condition is found. Because of this, the procedure execution Exits. If the Sql%NotFound is commented, then the Record gets updated. Please help me as to any special scenario which is validating Sql%NotFound condition to True.
After an UPDATE I usually use SQL%ROWCOUNT to check or log the number of rows affected by the update.
The definition of SQL%NOTFOUND is clear, it returns: