1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
|
CREATE or REPLACE TRIGGER serveillance_table_Generix
BEFORE INSERT on Generix -- ta table à surveiller
DECLARE
v_numbadge varchar2 (8);
v_terminal varchar2(30);
BEGIN
select osuser, terminal into v_numbadge, v_terminal from v$session
where status = 'ACTIVE' and type = 'USER';
INSERT INTO TMP_INSERTS
values ( v_numbadge,
sysdate,
v_terminal,
(ora_sysevent ||' ' || ora_dict_obj_type || ' ' || ora_dict_obj_name) );
EXCEPTION when others then
v_numbadge := 'XXXXX';
END;
/ |
Partager