同一数据库不同用户的两张表双向同步--触发器+包

1.新建package（A用户中）
create or replace package pk_check_active is
  --标识是否为触发器引发
  n number :=0;
  --获取是否为触发器触发标识，1为触发器触发
  function getactive return number;
  --设置状态
  procedure setactive(n1 in number);
end pk_check_active;
2.新建packageBody（A用户中）
create or replace package body pk_check_active as


  function getactive return number is
  begin
    return n;
  end getactive;
  procedure setactive(n1 in number) is
  begin
    n := n1;
  end setactive;
end pk_check_active;
3.A触发器
create or replace trigger tri_A
  after DELETE OR INSERT OR UPDATE on tableNameA
  for each row
declare
  -- local variables here
begin
  if pk_check_active.getactive() =1 then
     pk_check_active.setactive(0);  return;
  else
     pk_check_active._setactive(1);
  end if;