O'Reilly logo

Expert Oracle PL/SQL by Michael McLaughlin, Ron Hardman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required