authen
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_clear_my_lock_record
Parameters
Name
Type
Mode
i_prop_code
text
IN
i_user_name
text
IN
Definition
declare v_sql text; v_result boolean; begin if upper(i_prop_code) = 'NEWSOFT' then return true; end if; select unlock_result from dblink(fn_prop_connection(i_prop_code::citext), format('SELECT sp_unlock_all_register_record_lock_by_user_name(%L)', i_user_name) ) as t(unlock_result boolean) into v_result; -- v_sql := format( -- $sql$ -- select result -- from dblink(%L, %L) as t(result boolean) -- $sql$, -- fn_prop_connection(i_prop_code::citext), -- format('SELECT * FROM sp_unlock_all_register_record_lock_by_user_name(%L)', i_user_name) -- ); -- -- execute v_sql into v_result; return v_result; end;