DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to wait of trigger execution

  1. #1
    Join Date
    Mar 2002
    Posts
    303

    How to wait of trigger execution

    Hi,

    i want to run 3 procs in one main stored procedure, but between each execution there is a trigger. The trigger take a while.
    I would like that the next procs wait the end of the trigger?


    Example:
    Main procedure

    exec proc1; (at the end of proc1 a trigger1 starts)
    exec proc2; (at the beginnen of proc2, it must wait of the exec of trigger1. at the end trigger2 starts)
    exec proc3; ....


    Thank's

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    what sort of trigger are you talking about?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Mar 2002
    Posts
    303
    After update trigger.

    This trigger runs others stored procedures.

Posting Permissions

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


Click Here to Expand Forum to Full Width