Re: TRIGGER-Name of the current table

Taras wrote:
> Hello,
>
> I'm fairly new at PL-SQL, so forgive mi if this question sounds
> stupid...
>
> I'm trying to write a trigger on a certain table. Is it possible to
> retrieve the name of that table within the code of it's trigger?
>
> My goal is to write a code for universal trigger (it would do the same
> thing on all tables). That trigger would call a procedure and pass the
> name of it's parent table as a parameter.
>
>
> Regards,
> Taras

Look at the ORA_DICT_OBJ_NAME system event environment variable. You will find it documented at http://tahiti.oracle.com and a live demo in Morgan's Library at www.psoug.org.

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group