Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2012
    Posts
    15

    Unanswered: Cannot execute a nested stored procedure from a trigger

    Hi all!

    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.
    Thank you!

    P.S. I have ASE 15.0.3 ESD #4

  2. #2
    Join Date
    Feb 2012
    Posts
    133
    how does your stored procedure inside trigger perform?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •