Chapter 8, Problem 5SCG

Program Plan Intro

Stored procedures:

• A procedure is a collection of procedural and SQL statements.
• A procedure may have input parameter or output parameter or both parameters.
• It is declared with a unique name 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;

    Return (value or expression);

END;