How to fire the second concurrent program after a fixed time duration
I am trying to execute two concurrent reqeusts thourgh procedure. I am using fnd_request.submit_request api to call the concurrent requests. Its working fine. Now what I want is to fire the second concurrent request after 30 seconds. How can I do that. I have tried using dbms_lock.sleep function which was not helpful. Beacuse it was not making delay for the second program only it was locking the first request also (all the requests).
I want the first request to run for 30 seconds. In 30 seconds it will do some job and then I need to fire second concurrent request which can do some other jod based on the first one. Please note that I dont want the first program to finish and then fire second want.