Stored Subprograms (Procedures, Functions, and Packages)

  • Bulusu Lakshman


T he universal concept of a PL/SQL program is that the PL/SQL block could be one of three types: an anonymous block, a labeled block, or a named block. The PL/SQL block is quite handy in coding PL/SQL programs tailored toward a specific function and employing other PL/SQL programming constructs. However, it has a disadvantage: You can’t store it in the database like you can a table. If you need to share a block within another application, then you must rewrite it for that specific application. How easy and efficient would it be if the code were shareable? PL/SQL provides you with a mechanism, the stored subprogram, that permits you to share code between applications. A stored subprogram has the major advantage of being stored in the database and it’s therefore shareable.


Actual Parameter Formal Parameter Package Specification Reusable Package Return Type 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Bulusu Lakshman 2003

Authors and Affiliations

  • Bulusu Lakshman

There are no affiliations available

Personalised recommendations