Stored Functions, Procedures, and Packages

PL/SQL stored programming units are functions, procedures, packages, and triggers. Oracle maintains a unique list of stored object names for tables, views, sequences, stored programs, and types. This list is known as a namespace. Stored functions, procedures, and packages provide a way to hide implementation details in a program unit. While triggers work along the same lines as functions and procedures, they serve a different purpose that is covered in the next section of this appendix. Triggers also have their own separate namespace in Oracle, which means a trigger can have the same name as a table, view, stored program, sequence, or type.

PL/SQL implements functions with pass-by-value parameters and ...

Get Oracle Database 10g Express Edition PHP Web Programming now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.