Oracle Database 11g: Subprograms, Packages, and Exception Handling

Overview/Description
To identify the steps for designing, debugging, invoking, and bundling PL/SQL subprograms, procedures and functions, and also for handling their exceptions.

Target Audience
System analysts, PL/SQL developers, forms and application developers, database administrators, technical consultants, and portal developers.

Prerequisites
Previous programming experience and knowledge of SQL

Expected Duration (hours)
2.3

Lesson Objectives

Oracle Database 11g: Subprograms, Packages, and Exception Handling

identify the benefits of modularized and layered subprogram design.

recognize the steps for creating and calling procedures and passing parameters.

identify the steps for handling exceptions in procedures and for dropping procedures.

recognize the steps for creating and invoking functions.

recognize the steps for using SQL Developer to debug PL/SQL subprograms.

identify the benefits and components of a package, and recognize the steps for creating one.

create a package specification and package body in a given scenario, and invoke the package's constructs.