Procedures, Functions, and Packages
In the chapter on PL/SQL, you saw how powerful and useful this programming language could be. I’m sure any developers reading it also noticed that it was a little limiting though. All there seemed to be were anonymous (unnamed), self-contained blocks of code that can be run from the SQL*Plus prompt. Well that is not the case at all. Developers can name their PL/SQL blocks, parameterize them, store them in the database and reference or run them from any database client or facility such as SQL*Plus, Pro*C, or even JDBC.
KeywordsPublic Procedure Exception Handler Database Object Positional Notation Package Body
Unable to display preview. Download preview PDF.