Basic HTML version of Foils prepared 7 October 97

Foil 27 PL/SQL Stored Procedure

From untitled presentation ARL Database Tutorial -- February 98. by Gang Cheng, C.W. Ou, Geoffrey C. Fox
A standalone stored procedure has two parts
  • Specification - declare the procedure with the procedure name and its argument list (names and their databtypes)
  • Body - define the procedure with a PL/SQL block consists of SQL and PL/SQL statement
  • Both parts are created in one step using the CREATE PROCEDURE command
Basic Structure:

© 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