O'Reilly logo

Oracle Database 11g PL/SQL Programming Workbook by John M. Harper, Michael McLaughlin

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

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

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