SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Run PL/SQL analymous block in multi-threaded unix script

Top_Turn_BuckleDec 31 2020

Hello Experts,
Oracle DB version : 12c
We have a multi-threaded bash script (number of threads = 10).
We intend to run anonymous pl/sql blocks (performing DML operations) in these scripts.
Could you please let me know the design approach that may be taken for this problem so that table locks can be avoided.
I have heard about dbms_parallel_execute package. However, is there a way to run the pl/sql anonymous blocks without using this package.

Thanks and Regards.

This post has been answered by Paulzip on Dec 31 2020

Jump to Answer

Added on Dec 31 2020

#plsql

5 comments

496 views