I have come up with a trigger(insert delete update on TAB) which calls a standardized package that inserts query information into a custom table. We want to use this same package for triggers on multiple tables. I am having problems capturing the table name.
Is there any function that gives me the name of triggering table.... in our case TAB
I tried dbms_stanadard.dictionary_obj_name, tried ora_dict_obj_name too..... both are not working. I see the table column as empty.