问oracle proc通过dblink使用另一个表更新

EN

CREATE OR REPLACE PROCEDURE ASSGN_OF_ID
IS
  v_transID varchar2 (30);
  v_person_id NUMBER (12);
  v_long_id NVARCHAR2 (15);
  v_tranactions_date date;
  v_assgn_id varchar2 (30);
  v_t_emp_id varchar2 (30);
BEGIN
  select max(transID) into v_transID from tranactions;
--
  select personid, tranactionsdtm into v_person_id, v_tranactions_date
  from tranactions
  where transID = v_transID;
--
  select lirrnum into v_long_id
  from ptsadmin.person
  where personid = v_person_id;
--
  select emp_mstr_id into v_t_emp_id
  from wok.emp_mstr@T_DBLINK
  where emp_nbr = v_long_id;
--
  select asgn_id into v_assgn_id
  from wok.slip_mstr@T_DBLINK
  where emp_mstr_id = v_t_emp_id
  and trunc(v_tranactions_date) = trunc(eff_date_time);
--
  update tranactions set t_asgn_id = v_assgn_id where transID = v_transID;
--
  COMMIT;
END;

select emp_mstr_id into v_t_emp_id
from wok.emp_mstr@T_DBLINK
where emp_nbr = v_long_id;