I would like to execute the following procedures at a interval of 10 minutes. In order to do this I put a sys.DBMS_LOCK.sleep (<>);. This code is inside a procedure
Code: Select all
But the problem I faced is my calling application page stays remain till the second procedure finishes. I would like to the close the page as soon as the user submits the page.
What is the best way to resolve this problem? Any asynchronous method of doing this?