<div>
I haven't tried this, but perhaps pop the data pump execution into a new shell, and then wait for successful status on its completion before You Exit or move on from the procedure?
</div>


I haven't tried this, but perhaps pop the data pump execution into a new shell, and then wait for successful status on its completion before You Exit or move on from the procedure?

<div>
@sdstuber thanks. That worked<br />
@Abhimanyu Suri thanks for the link, i will explore more
</div>


@sdstuber thanks. That worked
@Abhimanyu Suri thanks for the link, i will explore more

<div>
glad I could help, don't forget to close the question.
</div>


glad I could help, don't forget to close the question.

<div>
<div class="content wysiwyg-content">
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.<br />
<br />
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?<br />
<br />
Please let me know
</div>
</div>


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

import data

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.