I need to write a procedure which will be called by triggers placed on
hundreds of different tables to carry out logging of changes. The process
involved is identical for all tables so a common procedure working with
passed parameters would seem the most maintainable. The problem I have is
that the table name and field name are recorded on the log.
Is the table name available to the trigger placed on a table? I know I could
"hard-code" the table name in the trigger but I would rather pick it up.
Is the field name available - I know OLD and NEW values for the field data
are available but I need the field name too.
I'm new to PL/SQL coding so if the answer is obvious then please don't
Re: oracle trigger
the maintenance of triggers is looked after by the databse. there is a
table USER_TRIGGERS in which all the user defined triggers will be there.
while defining the trigger, you specify the values of trigger, like when
do let it fired and on which table it to be fired and is it table level trigger
or row level trigger. in that table all these values will be there.
this table we can access. this will not be visible. but we can access. these
type of tables are calles META DATA.
hope you find the solution
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL