Oracle Database 11g: Working with Exceptions, Subprograms, JDeveloper, and REF Cursors

Overview/Description
To recognize ways to handle unanticipated errors in PL/SQL, write stored procedures and functions, deploy Java applications and Web services, and use cursor variables.

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 paths.

Expected Duration (hours)
2.0

Lesson Objectives

Oracle Database 11g: Working with Exceptions, Subprograms, JDeveloper, and REF Cursors

identify the steps for trapping non-predefined exceptions in PL/SQL.

recognize the steps for trapping user-defined exceptions.

create an exception handler in a given scenario.

identify the steps for creating and invoking simple stored procedures and functions.

recognize the scope and capabilities of JDeveloper for developing and deploying Java applications and Web services.

recognize the steps for using cursor variables to pass query result sets, and for fetching rows from them.