object name

hi everyone,

it might sound like a silly questions.

I have a trigger with a name like BEF_TBL_INS_ROW. In the exception section, I would like to insert a row in a log_table with some details about the trigger/exception. One thing is that I would like to store the name of the trigger (as current module) in the log_table.
Is there a system variable or a func_call which returns the name of the current module ('BEF_TBL_INS_ROW').
I know I could use the name of the trigger as literal in the insert statement. But I would prefer to use a system_var or func call (if available).

I wonder whether someone has a solution for me. Any help much appreciated.

Thanks in advance.
Fred Received on Tue Oct 26 2004 - 19:04:09 CDT