Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Logon trigger questions
I am using Oracle 9.2.0.5 on HP NIX 11i but question is general.
I am developing a logon trigger for running some alter session commands. However, if there is any error in execution of logon trigger, I will still like logon to succeed. In addition, I will like record Oracle error message in alert.log.
CREATE OR REPLACE TRIGGER my_logon AFTER LOGON ON database BEGIN
END;