Re: check source of trigger

On Friday 20 Sep 2002 9:25 am, wit wrote:

> I have trigger and procedure on table B to capture any change and insert
> into table logB:
>     create trigger trigger_b before insert or update or delete on B for
> each row execute procedure log_change();
>
> When I update e_codeA in table A, the constrain trigger will update e_codeA
> in B. My trigger, trigger_b, also was trigged and procedure will record
> change into table logB too.
> How to write a code in my db procedure to check whether the procedure was
> called by normal SQL or was called by cascade trigger.

There are a number of "special" variables defined if you are a trigger
procedure (not just OLD and NEW) - is that what you were after (Programmers
manual, ch 23.9)

- Richard Huxton