Re: Oracle 7.3 Triggers

Rupesh Kapoor <rupesh_at_whowhere.com> 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

Others have covered issues of conditional logic, your question appears how to actually programmatically control the execution by some other means. A tactic I've tested (albeit not with some triggers) is to have the "public" variables of a package set by an application call to a specific "initialization" procedure within a package and have triggers invoke procedures/functions of the same package.

As these procedures/functions are executing, they have access to the public variables modified/manipulated by the prior call to other procedures/functions in the same package.

hth & Regards,
Jim Buckley Received on Fri Jan 10 1997 - 00:00:00 CST