aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_unlock_all_register_record_lock_by_user_name
Parameters
Name
Type
Mode
i_lock_user
text
IN
Definition
declare v_count integer; begin delete from record_lock where (upper(lock_user) is not distinct from upper(i_lock_user)); get diagnostics v_count = row_count; if v_count = 0 then return false; else return true; end if; exception when others then return false; end