Re: disable triggers for my (or any) session only

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Thu, 17 Feb 2005 18:32:04 GMT
Message-ID: <4214e308.1287522819@localhost>

no, just wanted to disable a trigger for a large update i was doing for my session only (other sessions should still fire it)

On Thu, 17 Feb 2005 12:21:11 -0500, "Mark C. Stock" <mcstockX_at_Xenquery .com> wrote:

>
>"NetComrade" <netcomradeNSPAM_at_bookexchange.net> wrote in message
>news:4214d04c.1282727504_at_localhost...
>> Any way to do it?
>> .......
>> We use Oracle 8.1.7.4 and 9.2.0.5 on Solaris 2.7 boxes
>> remove NSPAM to email
>
>if you mean, triggers execute conditionally based on user's session
>(account, username, etc), then IFAIK, no -- you'd have to code that in the
>trigger or in a standard procedure that's called at the beginning of each
>trigger
>
>++ mcs
>
>

.......
We use Oracle 8.1.7.4 and 9.2.0.5 on Solaris 2.7 boxes remove NSPAM to email Received on Thu Feb 17 2005 - 12:32:04 CST