SQL Language Guide : 8. SQL Statements : WHENEVER : Locking
 
Share this page                  
Locking
In general, the WHENEVER statement has no impact. However, if the specified action is stop, any locks held are dropped because this action terminates execution of the program.