50%(2)1 out of 2 people found this document helpful
This preview shows page 1 - 4 out of 33 pages.
Lemuel TakuITD 134Class #: 15Homework Chapter 5Review QuestionsCC11 – A named program unit is a PL/SQL code block with a name. It consists of three parts:Declaration Part - Defining the program unit name, calling parameters, local variables and local procedures. Declaration part is required.Execution Part - Defining execution logic with executable statements. Execution part is required.Exception Part - Defining error handling logics. Exception part is optional.There are two types of named program units:Procedure - Has no return values.Function - Has a return value.12 The output from the calls to put_line( ) give you enough information to find out how the procedure runs and what values are stored in variables at different times. Had the procedure failed during execution, you would know the line it failed on depending on what output was produced and what output was not produced.