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 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.