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 ...