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.