Re: Trigger having knowledge of Table Name

jlipner_at_my-deja.com wrote:
>
> Is there any way for a trigger to have knowledge of the NAME OF THE
> TABLE that is being INSERTED, UPDATED, or DELETED to, without any
> outside help? We are solve this with global package level variables
> (common_pkg.table_being_processed) but this still requires the
> application to set the value right before the INSERT, UPDATE, or
> DELETE. We're looking for something that will simply tell us the table
> name (accurately, consistently) directly in the trigger, from the
> dictionary or a reserved variable or something else of the kind.
>
> Thanks
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Possibly name your triggers in some way that includes the table and use dbms_utility.format_call_stack ...

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse