Find out the table name inside the trigger code

From: Martic Zoran <zoran_martic_at_yahoo.com>
Date: Mon, 13 Dec 2004 02:09:38 -0800 (PST)
Message-ID: <20041213100938.86545.qmail@web52610.mail.yahoo.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Dec 13 2004 - 04:07:35 CST