create or replace trigger current_err_trigger --多了个trigger
after servererror on database
declare
v_user varchar2(30);
v_osuser varchar2(30);
v_machine varchar2(64);
v_process varchar2(8);
v_program varchar2(48);
v_sql varchar2(200);
begin
select username, osuser, machine, process, program,get_sql(a.sql_address,a.sql_hash_value) sql
into v_user, v_osuser, v_machine, v_process, v_program,v_sql
from sys.v_$session
where audsid = userenv('sessionid');
insert into save_err_audit
values(dbms_standard.server_error(1),
sysdate,v_user,
v_osuser,
v_machine,
v_process,
v_program,
v_sql);
end;
after servererror on database
declare
v_user varchar2(30);
v_osuser varchar2(30);
v_machine varchar2(64);
v_process varchar2(8);
v_program varchar2(48);
v_sql varchar2(200);
begin
select username, osuser, machine, process, program,get_sql(a.sql_address,a.sql_hash_value) sql
into v_user, v_osuser, v_machine, v_process, v_program,v_sql
from sys.v_$session
where audsid = userenv('sessionid');
insert into save_err_audit
values(dbms_standard.server_error(1),
sysdate,v_user,
v_osuser,
v_machine,
v_process,
v_program,
v_sql);
end;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货