Re: Trigger having knowledge of Table Name

I am struggling to find a reason why you might want to do this. Given that the syntax trigger creation requires you to specify the table name, what's wrong with:

    my_name varchar2(32) := 'TABLE_NAME'; being declared in the trigger ?

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

jlipner_at_my-deja.com wrote in message <8p3p5c$gj5$1_at_nnrp1.deja.com>...


>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.