Re: Oracle Stored Procedures

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Thu, 17 May 2001 11:08:41 +0200
Message-ID: <3B039519.4B9AD617@mytoys.de>

> > > Can I do that?
> > > if so, how?
> >
> > No idea. How should the trigger "know" at what value it has to fire
> > when you don't want to touch the database?
> > The only suggestion I have is to enter the value in a parameter table
> > and let the trigger query that table. But that will definitly cost
> > performance.
> >
> > Regards,
> >
> > Knut
>
> Put it as a constant in a package specification.
> Of course if the constant changes the trigger will need to be recompiled.

But that is what he doesn't want to do (as I understood his question). He doesn't want to recompile the trigger, maybe the trigger should have some sort of AI...

Regards,

Knut Received on Thu May 17 2001 - 04:08:41 CDT