O'Reilly logo

Oracle Database 10g PL/SQL Programming by Michael McLaughlin, Ron Hardman, Scott Urman

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 9Using Procedures, Functions, and Packages

In the last chapter, we discussed the details of creating procedures, packages, and functions. In this chapter, we will look at some of their features, including the difference between stored and local subprograms, how stored subprograms interact with the data dictionary, and how to call stored subprograms from SQL statements. We will also examine some features of stored subprograms new in Oracle9i and Oracle10g. The examples we use are dependent on database tables found in tables.sql. We need to run tables.sql before testing the example files. We will examine triggers in Chapter 10.

Subprogram Locations

Subprograms and packages can be stored in the data dictionary, as all of the examples in ...

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