Find out the table name inside the trigger code
- From: Martic Zoran <zoran_martic@xxxxxxxxx>
- To: 'Oracle-L Freelists' <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 13 Dec 2004 02:09:38 -0800 (PST)
Hi,
Is it possible to find out the table name in the
trigger code at execution time?
Cannot figure out any possible way.
Not crazy important but interesting if you want the
trigger code across many tables to look the same
(stupid, but anyway :)
The solution can be some environment variable or the
custom SQL) or wahetever, just to not hard code the
name of the table/trigger if possible :)
Thanks in advance.
Regards,
Zoran Martic
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
//www.freelists.org/webpage/oracle-l
Other related posts: