recipients of list ORACLE-L |
| [EMAIL PROTECTED] |
| cc: (bcc: PK Deepa/VGIL) |
| Subject: Re: Database trigger to record user |
| log
Hi ,
We want to create a database trigger to maintain the log history of
transaction tables (Not the Oracle Archive Log).
Our requirement is to create a common Oracle database trigger. Only the
table name will be different in these
triggers. The column names can be taken from all_tab_columns
[EMAIL PROTECTED] wrote:
Hi ,
We want to create a database trigger to maintain the log history of
transaction tables (Not the Oracle Archive Log).
Our requirement is to create a common Oracle database trigger. Only the
table name will be different in these
triggers. The column names
Wouldn't you have to use two triggers, one to capture the before image, and
one to capture the after image? Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 17, 2002 4:38 AM
[EMAIL PROTECTED] wrote:
Hi ,
We want to
No inside a trigger :new.Column_name, and :old.column_name gives the before
and after values
regards
naveen
-Original Message-
Sent: Thursday, October 17, 2002 6:19 PM
To: Multiple recipients of list ORACLE-L
Wouldn't you have to use two triggers, one to capture the before image, and
[EMAIL PROTECTED]@fatcity.com on 10/17/2002 03:13:26 AM
Please respond to [EMAIL PROTECTED]
Sent by:[EMAIL PROTECTED]
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
I guess, the problem you're having is that, ':new'||v_column is understood
as a string and not as