Ines Liefeldt wrote:

> Hallo, 
> 
> it's an unending story with triggers!
> 
> Now I have a problem with Stack overflow, when I will start 
> - an insert in table a, which starts 
> - an insert trigger of a, which starts
> - a dbprocedure p_a including an update of table b, which starts
> - an update trigger of b, which starts
> - a dbprocedure p_b including an update of table c, which starts
> - an update trigger of c
> 
> Already the dbprocedure p_b shows the message "Stack overflow".
> 
> In the SAP library I have found this error means that the 
> limit of nesting depth of the calls is reached.
> 
> What can I do to avoid this?

- bring database to offline-mode
- increase installation-parameter _MAXTASK_STACK using DBM
- restart database

good luck

Elke
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to