Subject | Trigger - Indirect Access to OLD / NEW context variables |
---|---|
Author | gorepj |
Post date | 2010-02-10T06:18:05Z |
I would like to implement generic code to access OLD and NEW context variables within a trigger.
So
A) can I derive the Tablename within a trigger
B) Can I access the context variables using an array or some other variable
e.g. I can derive the column names if I know the table name
Knowing the column name can I access its value e.g. ColName1.OLD
Ultimately I want to pass the Tablename and Primary key values from a Trigger to a Stored procedure
regards
Peter
So
A) can I derive the Tablename within a trigger
B) Can I access the context variables using an array or some other variable
e.g. I can derive the column names if I know the table name
Knowing the column name can I access its value e.g. ColName1.OLD
Ultimately I want to pass the Tablename and Primary key values from a Trigger to a Stored procedure
regards
Peter