Citation:
PAVMA02)>CREATE or REPLACE TRIGGER serveillance_migrations
2 BEFORE CREATE or DROP or ALTER or TRUNCATE on SCHEMA
3 DECLARE
4 v_numbadge varchar2 (8);
5 v_terminal varchar2(30);
6 BEGIN
7 select osuser, terminal into v_numbadge, v_terminal from v$session
8 where status = 'ACTIVE' and type = 'USER';
9 INSERT INTO UPAV.TMPMIGRATIONS
10 values ( v_numbadge,
11 sysdate,
12 v_terminal,
13 (ora_sysevent ||' ' || ora_dict_obj_type || ' ' || ora_dict_obj_name) );
14 EXCEPTION when others then
15 v_numbadge := 'XXXXX';
16 END;
17 /
Warning: Trigger created with compilation errors.
PAVMA02)>show errors
Errors for TRIGGER SERVEILLANCE_MIGRATIONS:
LINE/COL
---------------------------------------------------------------------------------
ERROR
-----------------------------------------------------------------------------------------------
5/3
PL/SQL: SQL Statement ignored
5/61
PL/SQL: ORA-00942: table or view does not exist
PAVMA02)>
La tables UPAV.TMPMIGRATIONS et la vue v$session existent bien, puisque si je fais un desc, je les vois bien...