No rows are deleted if an error occurs during the execution of a DELETE statement. The cursor is closed if an error occurs that makes the position of a cursor unpredictable.
Unless appropriate locks already exist, one or more exclusive locks are acquired by the execution of a successful DELETE statement. Unless the locks are released by a rollback operation, a deleted row cannot be accessed by any unit of recovery.
|
Copyright © 2014 CA.
All rights reserved.
|
|