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 12:21:11 -0500
Message-ID: <zvCdnTR3vJERT4nfRVn-sA@comcast.com>

"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 Received on Thu Feb 17 2005 - 11:21:11 CST

Original text of this message

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