Oracle Database 11g: Subprograms, Packages, and Exception Handling in PL/SQL

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
Application developers, database designers, database administrators, forms developers, PL/SQL developers, and technical consultants

Prerequisites
The learner should have experience and knowledge with SQL, specifically the Oracle Database 11g: SQL Fundamentals I and Oracle Database 11g: SQL Fundamentals II learning

Expected Duration (hours)
2.3

Lesson Objectives

Oracle Database 11g: Subprograms, Packages, and Exception Handling in PL/SQL

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.