O'Reilly logo

Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts by John Adolph Palinski

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

Named Procedures

The code blocks that have been illustrated thus far have been anonymous procedures that may be executed from only an external file. This requires Oracle to search the hard drive for the file, load it into memory, compile the state-ments, and execute the procedure. Code blocks may also be defined as database objects, meaning that the code block resides within the database in a compiled form; therefore, performance will be greater using these types of procedures.

There are two types of database code blocks: named procedures and functions. The difference between the two is that the named procedure can be executed as a statement of its own, and a function is always used as an argument within a statement. Another difference is that ...

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