Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 7.3 Triggers
As you know triggers definitely do not accept arguments. But a simple way to do this is have a packaged variable and a pacakaged procedure and initialize the variable and call the procedure inside the trigger. The procedure will first check the value of the variable before ececuting the logic ( ofcourse you got to write it that way). This technique will help if all your application instances are under the same oracle session.
Good Luck
Sree
Received on Sun Jan 05 1997 - 00:00:00 CST