I have a trigger, below is the code:
create or replace trigger blah
WHEN others THEN
Basically, I want to write the error into the txt file, so I create another procedure called error_log, so everytime if there is an error, it will write to the log file for me. what I want is to captured the data and time of the error b/c right now I can only see the error without knowing when it happened.