Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: disable triggers for my (or any) session only

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

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 17 Feb 2005 13:39:41 -0500
Message-ID: <TIadnbQk9JJveYnfRVn-gg@comcast.com>

"NetComrade" <netcomradeNSPAM_at_bookexchange.net> wrote in message news:4214e308.1287522819_at_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

yeah, that's exactly what i thought you were getting at

no, triggers are enabled or disabled. there are some scenarios where they don't fire (such as truncate table), but you can't be selective on a per session basis. the basic idea of triggers is to enforce a condition regardless of what the application (mid-tier or client) attempts

++ mcs Received on Thu Feb 17 2005 - 12:39:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US