数据库里面有一张表GG_FMIS_BILL,记录数据的同步日志,现在问题来了,代码更新后,理论上报错信息内容是B,但一半的报错内容是A。到底是哪些节点导致呢?这种场景用到触发器记录源weblogic的IP等信息:
drop table test;
create table test(
BILL_ID VARCHAR2(50),
OS_USER VARCHAR2(50),
SESSION_USER VARCHAR2(50),
TERMINAL VARCHAR2(50),
IP_ADDRESS VARCHAR2(50),
HOST VARCHAR2(50),
CURRENT_USER1 VARCHAR2(50),
create_date date
);
create index ind_t_bill_id on test(bill_id) nologging;
Create or replace trigger wz_test
After insert on GG_FMIS_BILL
For each row
Declare
begin
insert into test select :new.BILL_ID,sys_context('USERENV', 'OS_USER') OS_USER,
sys_context('USERENV', 'SESSION_USER') SESSION_USER,
sys_context('USERENV', 'TERMINAL') TERMINAL,
sys_context('USERENV', 'IP_ADDRESS') IP_ADDRESS,
sys_context('USERENV', 'HOST') HOST,
sys_context('USERENV', 'CURRENT_USER') CURRENT_USER,
sysdate
from dual;
end;