Explicit Cursors and Exception Errors

Overview/Description
To use the FOR UPDATE and WHERE CURRENT OF clauses to lock and modify rows, process data using records and cursors, and outline how each of the PL/SQL exception types are raised and handled

Target Audience
Database administrators, application developers, and database operators

Prerequisites
Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases and the SQL programming language; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata

Expected Duration (hours)
3.1

Lesson Objectives

Explicit Cursors and Exception Errors

use explicit cursors to retrieve data.

process data using records, cursor attributes, and cursor FOR loops.

use parameters to make cursors reusable in a given scenario.

use the FOR UPDATE and WHERE CURRENT OF clauses to lock and modify rows.

use an explicit cursor to retrieve and update data.

outline how each of the PL/SQL exception types are raised and handled.

trap predefined and non-predefined exceptions in PL/SQL.

trap user-defined exceptions and identify error codes and messages.

use nested blocks and the RAISE_APPLICATION_ERROR procedure when handling exceptions in PL/SQL.

handle exceptions in PL/SQL.