Unanswered: Cannot execute a nested stored procedure from a trigger
I faced with a strange problem.
I have a trigger which executes a stored procedure. When executed this procedure cannot execute any other nested procedure or even run an "exec ()" statement. In other words I have the following process: Trigger -> Procedure 1 -> Procedure 2 (nested). The Procedure 2 cannot be executed and no error is raised. It looks like ASE just ignores the "exec" statement. But if I run the Procedure 1 manually, I have no problem with executing nested procedure (Proedure 2).
I have no idea why this happens. I'd appreciate any advice.