need a small assistance
Hi,in my pl/sql procedure i am calling a concurrent program which is used to transfer the data from interface tables to base tables
once if the data moved from interface tables to base tables after that i need to update a another base table
the main problem is the concurrent request may takes some time for completing the request
based on the interface tables information only i need to update the base table(why because the concurrent program completes succes eithere the records are moved to base tables nor still they present in interface tables)
the code has to wait for some some time to update the base tables once after the concurrent program completes the request and after that we need to check the interface tables if data is present we need to raise an expection and if not present we need to update some base tables
once if the data moved from interface tables to base tables after that i need to update a another base table
the main problem is the concurrent request may takes some time for completing the request
based on the interface tables information only i need to update the base table(why because the concurrent program completes succes eithere the records are moved to base tables nor still they present in interface tables)
the code has to wait for some some time to update the base tables once after the concurrent program completes the request and after that we need to check the interface tables if data is present we need to raise an expection and if not present we need to update some base tables
0