Posted on 2016-08-10
I am using a impdp utility via datapump api in a plsql procedure. In the nightly batch load, the plsql procedure completes and moves on to the next job. Since next job kicks in before actual data loading into table is complete because plsql job successfully completed, it is causing side effects and errors in downstream jobs.
Is there a way to wait for all the data to be loaded into table before completing the plsql procedure is complete and move on to next job?
Please let me know