Oracle Database 11g: Using 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
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.0

Lesson Objectives

Oracle Database 11g: Using 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.