How create a trigger-like procedure on a SYS table???
From: deejay <djuravel_at_dgny.com>
Date: 4 Sep 2001 09:59:31 -0700
Message-ID: <f7b19882.0109040859.2801b08_at_posting.google.com>
[Quoted] I need something that will act like a trigger on a built in system table or view. Upon the update (insertion or deletion) of the built in view V$SESSION I need to track the change and notify another procedure. I tried creating a trigger on the V$SESSION table but since it belongs to SYS, it's not allowed. How can I get around this? Received on Tue Sep 04 2001 - 18:59:31 CEST
Date: 4 Sep 2001 09:59:31 -0700
Message-ID: <f7b19882.0109040859.2801b08_at_posting.google.com>
[Quoted] I need something that will act like a trigger on a built in system table or view. Upon the update (insertion or deletion) of the built in view V$SESSION I need to track the change and notify another procedure. I tried creating a trigger on the V$SESSION table but since it belongs to SYS, it's not allowed. How can I get around this? Received on Tue Sep 04 2001 - 18:59:31 CEST