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
1 CREATE OR REPLACE PACKAGE phone_pkg AS
  • PROCEDURE get_phone_by_no (no IN NUMBER);
  • PROCEDURE get_person_by_name (name IN VARCHAR2);
2 END phone_pkg;
3 /
4 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;
5 END phone_pkg;
6 /
in Table To:

© 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