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.