Chapter 7. Threading PL/SQL Execution
Threading PL/SQL code may be a new or old idea to you. If threading PL/SQL is a new idea, you'll find a complete solution in this chapter. If threading PL/SQL execution is an old idea, you'll learn techniques to control execution and the Oracle 10g migration strategy outside of the DBMS_JOB built-in package.
Oracle 7 through Oracle 9i provided two ways to create parallel PL/SQL execution. One is the building of a shell script to control execution. The other is the use of the DBMS_JOB package. The DBMS_JOB built-in package enables you to submit parallel or concurrent jobs within the native SQL environment. Unfortunately, Oracle 10g replaces DBMS_JOB with the DBMS_SCHEDULER built-in package and a disclaimer that ...
Get Expert Oracle PL/SQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
