Chapter 8, Problem 16P

Program Plan Intro

Stored procedures:

• A procedure is a collection of procedural and SQL statements.
• A procedure may have input parameter, output parameter and both parameters.
• It has a declared with a unique named with a unit of procedural code using the proprietary RDBMS and it is invoked by a host language library routine.

Syntax for stored procedure:

CREATE FUNCTION fun_name(argument IN data-type)RETRUN data-type[IS]

BEGIN

PL/SQL statements;

Retrun (value or expression);

END;