Home » SQL & PL/SQL » SQL & PL/SQL » After servererror on database (10g,11g)
After servererror on database [message #568489] Fri, 12 October 2012 04:46 Go to next message
rishwinger
Messages: 132
Registered: November 2011
Senior Member
Hi All,

I have a DBMS_JOB which fails due to unique constraint error while doing fast refresh.

I wrote a After servererror on database trigger to take backup of M$LOG file whenever unique constrint error occur

Problem

Q1)If error is being logged in alert log then After servererror on database trigger doesn't trigger. so no bkup,
Is this a normal behaviour because i was under the impression that if any error in DB occurs then "After servererror on database " will catch it?

If i manully try to do fast refersh it works fine

Q2) Is there any other way in Oracle to counter such issue?

Thx
Rishwinger

Re: After servererror on database [message #568506 is a reply to message #568489] Fri, 12 October 2012 09:00 Go to previous message
BlackSwan
Messages: 21945
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Previous Topic: sending email or not
Next Topic: How to use if exist condition in oracle
Goto Forum:
  


Current Time: Sat Apr 19 01:02:42 CDT 2014

Total time taken to generate the page: 0.23210 seconds