Core Concurrent Processing - EBS (MOSC)

MOSC Banner

How to fire the second concurrent program after a fixed time duration

edited Jan 29, 2014 10:13PM in Core Concurrent Processing - EBS (MOSC) 3 commentsAnswered
Hi All,

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center