Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 7.3 Triggers
Rupesh Kapoor wrote:
>
> Hi,
>
> I am using oracle triggers in an application which runs multiple
> instances at the same time. Is there any way to ask an SQL statement to
> *not* execute the trigger under certain circumstances? Is it possible to
> pass a parameter to the trigger? Disabling triggers will not help since
> other threads should be able to use triggers at the same time.
>
> Thanks
> Rupesh
you can set the triggers condititions such that it only executes when you need it. You can also code some logic in the trigger so that the trigger body is bypassed (using IF..THEN..ELSE) when a certain condition (some column value or for a certain user id) is met.
Ashok
-- Ashok F. Kapur | Galaxy Latin America | Project Engineer | (954)958-3373 | afkapur_at_ccgate.hac.comReceived on Mon Jan 06 1997 - 00:00:00 CST