I wrote this trigger in my Database.
create or replace TRIGGER pen_monitoring_others
BEFORE UPDATE ON invoices
REFERENCING NEW AS NEW
FOR EACH ROW
DECLARE
v_osuser varchar2(255);
BEGIN
select osuser into v_osuser from v$session where trim(program) like '%sql%' or trim(program) like '%SQL%'or trim(program) like 'exe%';
if :new.uti = v_osuser then
RAISE_APPLICATION_ERROR(-20000, 'Cette action est entrain de se faire avec le compte ou le code SQL+, avec un editeur SQL');
commit;
end if;
end pen_monitoring_others;
but I have the error : PL/SQL:SQL Statment ignore, PL/SQL:ORA-00942:Table ou vue inexistant.
I need you help to fixed this problem please.