Re: Oracle Stored Procedures

Thanks.
one more question.
when you define a trigger, as far as I understand, you have to operate on the table itself (please correct if i'm wrong). that makes a trigger a static rule associated with a table. how if I want that trigger to be configurable? for instance, I set my trigger to fire whenever the field salary gets an increase of += 20%. after some time i want to change that value to 15% without operating directly on the db.
Can I do that?
if so, how?

Thank you very much

"Knut Talman" <knut.talman_at_mytoys.de> ha scritto nel messaggio news:3B0246ED.7CD00218_at_mytoys.de...
> > Can anybody tell me what the difference is between
> > CREATE OR REPLACE PACKAGE
> > and
> > CREATE OR REPLACE TRIGGER
>
> You can understand a PACKAGE as a collection of procedures,
> functions, types which you have to call by yourself (explicitly).
> A TRIGGER is called implicitly when the condition, the trigger
> was designed for, becomes true (e.g. when you insert a row into
> the table, the trigger belongs to). A trigger is always connected
> to a table, it can not be run standalone.
>
> Regards,
>
> Knut
Received on Wed May 16 2001 - 07:39:38 CDT