Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Programming

 

ORA_SYSEVENT function returns the system event that was responsible for firing the trigger as a VARCHAR2 datatype

SQL> SQL> BEGIN   2    dbms_output.put_line(ora_sysevent||' fired the trigger.');   3  END;   4  / fired the trigger. PL/SQL procedure successfully completed. SQL>