Re: capture oracle errors

> As enticing as it sounds to have all such info dumped into udump, I
> have a bit of paranoia regarding setting events for routine use.

I do too, but I was just giving one way that Oracle can handle this and meet the OP's requirements.

Personally, I wouldn't code this event for normal Oracle errors. Rather, I'd modify the application code to handle errors appropriately. IMO, error trapping and handling should be done in the application code. And part of that can include application code that sits inside the database, i.e. stored procs, pkgs, triggers.

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"