Oracle® PL/SQL® Interactive Workbook, Second Edition

Lab 10.1 Exception Scope

Lab Objectives After this Lab, you will be able to: ✓ Understand the Scope of an Exception

You are already familiar with the term scope—for example, the scope of a variable. Even though variables and exceptions serve different purposes, the same scope rules apply to them. Now examine the scope of an exception by means of an example.

▪ FOR EXAMPLE

DECLARE 
   v_student_id NUMBER := &sv_student_id; 
   v_name VARCHAR2(30); 
BEGIN 
   SELECT RTRIM(first_name)||' '||RTRIM(last_name) 
     INTO v_name 
     FROM student 
    WHERE student_id = v_student_id; 

   DBMS_OUTPUT.PUT_LINE ('Student name is '||v_name); 
EXCEPTION 
   WHEN NO_DATA_FOUND THEN 
      DBMS_OUTPUT.PUT_LINE ('There is no such student'); 
END; 

In this example, you display the student’s name on the ...