create or replace trigger TRI_AAA
  before update or delete
   on AAA 
  for each row

declare
     ERR VARCHAR2(100);
--原表字段
TMP_PROJECT_ID NUMBER(16,0);
TMP_COMPANY_ID NUMBER(16,0);
TMP_CREATE_DATETIME DATE;
...
TMP_GROUP_ID NUMBER(16,0);
--新增字段
--TMP_USER_OPT VARCHAR2(64);
--TMP_USER_OPT_DATETIME DATE;
  PRAGMA AUTONOMOUS_TRANSACTION;
begin
TMP_PROJECT_ID:=:OLD.PROJECT_ID;
TMP_COMPANY_ID:=:OLD.COMPANY_ID;
TMP_CREATE_DATETIME:=:OLD.CREATE_DATETIME;
...
TMP_GROUP_ID:=:OLD.GROUP_ID;
if updating then
    INSERT INTO AAA_LOG(PROJECT_ID,COMPANY_ID,CREATE_DATETIME,...,TMP_GROUP_ID,'UPDATE',SYSDATE);
    commit;
elsif deleting then
        INSERT INTO AAA_LOG(PROJECT_ID,COMPANY_ID,CREATE_DATETIME,...,TMP_GROUP_ID,'UPDATE',SYSDATE);
    commit;
end if;

     EXCEPTION
      WHEN TOO_MANY_ROWS THEN
           INSERT INTO TAB_PUB_ERROR (userid, error, triname, tabfountain, tabend, edate)
                  VALUES(0,'TOO_MANY_ROWS','TRI_AAA','AAA','AAA',sysdate);
           COMMIT;
      WHEN NO_DATA_FOUND THEN
           INSERT INTO TAB_PUB_ERROR  (userid, error, triname, tabfountain, tabend, edate)
                  VALUES(0,'NO_DATA_FOUND','TRI_AAA','AAA','AAA',sysdate);
           COMMIT;
      WHEN OTHERS THEN
           err:=SUBSTR(SQLERRM(SQLCODE),1,100);
           INSERT INTO TAB_PUB_ERROR  (userid, error, triname, tabfountain, tabend, edate)
                  VALUES(0,err,'TRI_AAA','AAA','AAA',sysdate);
           COMMIT;
end;