CHAPTER 6Procedures

Procedures, like functions, are specialized subroutines. When they exist as standalone procedures, you call them schema-level procedures. Like functions, you can use procedures inside anonymous or other named PL/SQL blocks. They can also be defined and implemented inside packages and user-defined object types. There are two differences between procedures and functions: Unlike functions, procedures don’t have a formal return data type and can’t be used as an expression or right operand; and, unlike functions, you can’t call procedures in SQL statements.

Like functions, you can define a function in a package specification. This makes it a published procedure of the package. You can call published procedures from any schema that ...

Get Oracle Database 11g PL/SQL Programming Workbook now with O’Reilly online learning.

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