Re: capture oracle errors

Use database triggers to insert the errors into a table and have some process lookup the table and display.
The trigger would be something like:

create or replace trigger log_errors_trig after servererror on database
begin
...your code
...
end;
/

-Madhu S
hegyvari_at_ardents.hu (Hegyvari Krisztian) wrote in message news:<9003d46f.0308110433.4c501b19_at_posting.google.com>...
> Greetings,
>
> I am looking for a tool similar to SQL MOnitor from Quest software.
> What I would like:
>
> - the tool would be sitting silently in the background (an open window
> is not a problem, or perhaps something on the tray)
> - the tool logs only those calls which causes an Oracle error,
> together with the sql command and the bound variables
> - it has to be able to handle long batch processes without exhausting
> system memory resources (that's the problem with sql monitor)
>
> Any ideas?
>
> Best regards,
>
> Hegyvari Krisztian
>
> pls cc to hegyvari_at_ardents.hu
Received on Tue Aug 12 2003 - 17:25:49 CDT