On 2/18/19 9:11 AM, Jitendra Loyal wrote:
> I have gone through the documentation quite a number of times to
> establish the understanding. However, I had been wondering about the
> recursion in the case I put forth.
>
> Is there a better way to handle this requirement? The point is that the
> trigger is being called when no rows are affected.
Well as the docs say a FOR EACH STATEMENT trigger will execute in the
absence of changed rows. So you have two options:
1) Use a FOR EACH ROW trigger.
2) Do what you did and include a sanity check.
Best guess is your AFTER STATEMENT trigger is tripping your BEFORE ROW
trigger which then trips your AFTER STATEMENT and so on.
>
> Thanks and regards,
> Jiten
--
Adrian Klaver
adrian.klaver@aklaver.com