trap the time and date of the erorrs

[baseballGuy]

Hi Tim

I have a trigger, below is the code:

create or replace trigger blah
declare
med varchar(30)
begin
dud...
.......
EXCEPTION
WHEN others THEN
dbms_output.enable(100000);
dbms_output.put_line(SQLERRM) ;
error_log;
END;
/

Basically, I want to write the error into the txt file, so I create another procedure called error_log, so everytime if there is an error, it will write to the log file for me. what I want is to captured the data and time of the error b/c right now I can only see the error without knowing when it happened.

Thoughts?
Thanks Tim

[Tim...]

Hi.

If it's a row level trigger, you have access to the :new. and :old. attibutes.

Insert:

:new.colname - New value for a named column.

Update:

:new.colname - New value for a named column.
:old.colname - Value for the named column prior to update.

Delete:

:old.colname - Value for the named column prior to delete.

You can use this method for each of the columns in on the trigger table to access and log the data.

Cheers

Tim...

[baseballGuy]

your typing came up with funny sign......

[Tim...]

Hi.

I've turned off smilies for that post so you can read it properly.

Cheers

Tim...