Subject Re: Runtime stack overflow
Author Alexander V.Nevsky <>
--- In, "hcarvajalsy <hcarvajalsy@y...>"
<hcarvajalsy@y...> wrote:
> Hello,
> I am getting the following error whenever I do an update to one of
> my tables:
> Statement failed, SQLCODE = -901
> Stack overflow. The resource requirements of the runtime stack have
> exceeded the memory available to it.
> I have tested the update on other tables and it works. On my item
> table I get the error, I can do selects and deletes, but it crashes
> during the update. I will appreciate any help on this problem.

Horacio, check Update triggers on this table for recursion, i.e.
updates on the same table. It can be indirect, through trigger chain
on another tables, simpliest chain is trigger on table A updates table
B and trigger on table B updates table A.

Best regards, Alexander.