Can anyone please let me know how to trigger multiple procedures in parallel from a master procedure. The second child procedures should not wait for the completion of the first child procedure.
I can do this by creating two scheduled job, but I don’t want to do it using jobs.I tried the below code but the second child procedure always waits for the first procedure to complete and then only it starts. So please let me know if there are any other method to achieve this.
For example: There is a master procedure as MASTER_PROCEDURE and two child packages are triggered in parallel from the master procedure.
CREATE OR REPLACE PROCEDURE MASTER_PROCEDURE
Thanks in advance.