how to get the old value in a oracle event alert ?

From: <rmoleveld_at_gmail.com>
Date: 22 Nov 2005 01:59:44 -0800
Message-ID: <1132653584.869321.181470@f14g2000cwb.googlegroups.com>

Hi all,

I want to create an alert that tells me the changes on a specific field of a table when done.
Therefor I also need the old and the new value from that specific object.
Example:

mtl_material_items contains my items.
when the item_type changes from AA to BB I want to receive an email.

This can be done with a event alert on table mtl_material_items but just checking and/or comparing the old and new value from item_type is not known by me.

#1. is this possible
#2. ifso, how an I achieve this ?

Many thanks on forehand.

Ronald. Received on Tue Nov 22 2005 - 03:59:44 CST