Basic HTML version of Foils prepared 7 October 97

Foil 29 Example of A PL/SQL Package Structure

From untitled presentation ARL Database Tutorial -- February 98. by Gang Cheng, C.W. Ou, Geoffrey C. Fox
CREATE OR REPLACE PACKAGE phone_pkg AS
  • PROCEDURE get_phone_by_no (no IN NUMBER);
  • PROCEDURE get_person_by_name (name IN VARCHAR2);
END phone_pkg;
/
CREATE OR REPLACE PACKAGE BODY phone_pkg AS
  • PROCEDURE get_phone_by_no (no IN NUMBER) is
    • Begin
    • <procedure body>
  • End get_phone_by_no;
  • PROCEDURE get_person_by_name (name IN VARCHAR2) is
    • Begin
    • <procedure body>
  • End get_person_by_name;
END phone_pkg;
/

© 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