need to call 3 stored procedure at the same time

Shell Programming and Scripting
1

Hi GUYS,

I need to trigger 3 stored procedure at the same time..
I know how to trigger the stored procedure. If anybody can tell me how to trigger 3 different process at the same time parallelly.. that would be helpful..

Thanks for your help in advance,
Magesh

2

Insert "dummy" lines into 3 different tables, with each table having its own trigger. They won't quite go "in parallel" as they'd be triggered in sequence but you wouldn't get the second procedure waiting until the first has completed. Goodness knows what would happen if you did this in a transaction and rolled it back, though! :confused: