Oracle and PL/SQL Recipes: A Problem-Solution Approach

4-14. Executing Package Programs in Sequence

Problem

You have created a package that contains all the necessary procedures and functions for your program. Although you can invoke each of these subprograms individually using the package_name.subprogram_name notation, it would be beneficial to execute all of them at the same time by issuing a single statement.

Solution

Create a driver procedure within your PL/SQL package that will be used to initiate all the subprograms in turn, and run your entire program. In the following example, a procedure named driver is created inside a package, and it will invoke all the other package subprograms in turn:

First, create the specification:

CREATE OR REPLACE PACKAGE synchronize_data IS   PROCEDURE driver; ...