Why does a job loose its context? 2006-03-02 - By Ethan Post
Speaking of triggers not firing, anyone seen an example of where a
SERVERERROR trigger does not fire?
I was looking an an issue this week where a log file in an app is
reporting a ORA- error (no data found), so we added some logging to
the code and turned on SERVERERROR trigger. I was hoping to get
something like this in my log file.
..entering proc foo...
..ORA- error
...
However, I never got the ORA- error in my log (the application log
still reports it, but it is possible some developer has hard coded
this particular error string someplace where the error is not really
occurring, strange but possible).
The only other option is that the trigger is not firing, I see errors
for plenty of other sessions in the database. At first I thought it
was because I had the EVENT level elevated for this error and the dump
of a trace file was causing this, but we removed that and still
getting nothing.
--
http://www.freelists.org/webpage/oracle-l
|
|
