Basic HTML version of Foils prepared 7 October 97

Foil 37 Scope and Life time of Procedure and Package Variables, Constants, and Cursors

From untitled presentation ARL Database Tutorial -- February 98. by Gang Cheng, C.W. Ou, Geoffrey C. Fox
For procedure, their state persists only for the duration of a procedure call and is lost when the procedure execution terminates
For package
  • the state of packages declared in the specification or body (i.e., not within a procedure) persists for the duration of the user's session (i.e, across trnasactions)
  • every session of a package has its own set of package variables, constants and cursors
  • during a session, the package user can modify the values of the package variables and cursors
Overloading of Package Procedure Names - PL/SQL allows two or more procedures in the same package to have the same name.
  • This option is very useful where you need a procedure to accept arguments of different datatypes or different number of arguments

© Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Thu Feb 5 1998