Time delay required between two procedures
519523Apr 11 2007 — edited Apr 11 2007Hi
I have two procedures, which are being executed one after the other. My requirement is that I need to add a time delay of 1 second between the execution of the two procedures (i.e. after the procedure is executed, add a time delay of 1 second and then execute the second procedure). I know this can be done with dbms_lock.sleep(), but I don’t have access to use this function. So can anybody suggest me an alternative solution to add the time delay.
Thanks in advance,