Re: Tricky trigger
Date: Sun, 21 Feb 1999 22:49:39 GMT
Message-ID: <36d08d72.28163264_at_news.arnes.si>
On Sun, 21 Feb 1999 21:40:00 +0100, "Arjan van Bentem" <avbentem_at_DONT-YOU-DAREdds.nl> wrote:
>Thomas Kyte wrote
>
>>> trigger a PL/SQL procedure when an user close his connection
>
>>Not until Oracle8i (8.1)
>
>
>Just a wild thought: couldn't one enable auditing and put a trigger on the
>audit tables?
>
>Arjan.
Yes, this would be possible. But first you would have to move AUD$ table from SYS to some other schema (like SYSTEM, for example) and create a SYS.AUD$ synonym for it, because you can't attach triggers to SYS's tables.
[Quoted] But there is another catch with this method - if the trigger should write any information to some database table, then you are out of luck. Since you can't use COMMIT inside a trigger or inside any trigger-called procedure/function, all of those table changes will be [Quoted] rolled back at actual session ending (unless aplication has some kind of autocommit functionality turned on, like in SQL*Plus). I was pointed to this limitation of the proposed sollution a couple of months ago by someone in this NG, when I suggested the same sollution for the identical problem as you are suggesting here.
The introduction of DDL-event and system-event triggers into O8i is realy a very wellcome feature IMO.
Regards,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)
The above opinions are mine and do not represent any official standpoints of my employer Received on Sun Feb 21 1999 - 23:49:39 CET