PL/SQL (MOSC)

MOSC Banner

Regarding SYS.DBMS_LOCK.sleep() in fnd_concurrent.get_request_status()

edited Jul 23, 2012 8:53AM in PL/SQL (MOSC) 5 commentsAnswered
I have got a procedure at my Support project.The procedure is called after every submission of a Concurrent Request from the back-end. The procedure uses the fnd_concurrent.get_request_status() seeded API. There is a SYS.DBMS_LOCK.sleep(30) after the status check. I really wonder this SYS.DBMS_LOCK.sleep()  is required.It is causing an un necessary delay. Usage of fnd_concurrent.wait_for_request() may be one solution but we want to do it with fnd_concurrent.get_request_status() only.

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center