Stored procedures are part of the data base schema included with the application. A stored procedure may be one of the following:
  • Trigger - executed upon an event in the data base
  • Function - performs computations and/or data retrieval and returns a value to the calling program
  • Procedure - executes computations and/or data manipulation
  • Packages - a collection of functions and procedures that can also share variable values.