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