Advertisement

Procedures, Functions, and Packages

  • Sean Dillon
  • Christopher Beck
  • Thomas Kyte
  • Joel Kallman
  • Howard Rogers

Abstract

In the chapter on PL/SQL, you saw how powerful and useful this programming language could be. I’m sure any developers reading it also noticed that it was a little limiting though. All there seemed to be were anonymous (unnamed), self-contained blocks of code that can be run from the SQL*Plus prompt. Well that is not the case at all. Developers can name their PL/SQL blocks, parameterize them, store them in the database and reference or run them from any database client or facility such as SQL*Plus, Pro*C, or even JDBC.

Keywords

Public Procedure Exception Handler Database Object Positional Notation Package Body 
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.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Apress 2002

Authors and Affiliations

  • Sean Dillon
  • Christopher Beck
  • Thomas Kyte
  • Joel Kallman
  • Howard Rogers

There are no affiliations available

Personalised recommendations