19
Procedures
PL/SQL code that you have seen up to this point has been anonymous blocks that were run as scripts and compiled by the database server at runtime. In this and the next few chapters, you will begin to use modular code. Modular code is a methodology to build a program from distinct parts (subprograms), each of which performs a specific function or task toward the final objective of the program.
In PL/SQL, a subprogram is a named PL/SQL block that can accept parameters and that may be used repeatedly. A subprogram may be created either in a PL/SQL block, in a package, or at a schema level. Procedures and functions are examples of subprograms. ...
Get Oracle PL/SQL by Example, 6th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
