Hi All,
I wanted to make the further execution of a procedure in a package to wait for sometime without disturbing the execution of other procedure in pl/sql.
For eg:
I have two procedures in package,P1 and P2.
P1 is inserting data into tables and P2 is updating table.
In P1 I want to get the updated information of table which is updated in P2.
Suppose updation did not happen and P1 is trying to get the updated data , then I need to wait the Procedure P1 till P2 updates it.
How can I make P1 to wait for say 1 minute/2 minutes.
Your replies to this will be helpful to me.
Thanks,
Sukanya