aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_unlock_register_record_lock
Parameters
Name
Type
Mode
i_register_id
integer
IN
i_lock_user
text
IN
Definition
DECLARE v_count integer; BEGIN i_lock_user := coalesce(nullif(i_lock_user, ''), fn_current_user()); delete from record_lock where (register_id = i_register_id) and (upper(lock_user) = upper(i_lock_user)); get diagnostics v_count = row_count; RETURN v_count <> 0; EXCEPTION WHEN OTHERS THEN RETURN false; END