Deal with multiple exception branches

    

-- multiple exception branches


set echo on;
set verify off;
set define '&';

prompt 'Input degree (numerically in degrees F)?:';
/
accept temp default '100';
/
declare
  too_hot  exception;
  too_cold exception;
begin
  case
    when '&temp' < 90.00 then raise too_cold;
    when '&temp' > 140.00 then raise too_hot;
    else null;
  end case;

  dbms_output.put_line('The temperature is just right');

exception
  when VALUE_ERROR then
    dbms_output.put_line('Please enter a numeric temperature (like 100)');

  when too_hot then
    dbms_output.put_line('The porridge is way too hot...');

  when too_cold then
    dbms_output.put_line('The porridge is way too cold...');
end;
/

1.	Check exception type
2.	when other exceptions then
3.	Handle update exception
4.	declaration exception
5.	handle exception of duplicate value on index
6.	when other then not user-defined exception
7.	Using PRAGMA EXCEPTION_INIT
8.	Different Values of SQLCODE and SQLERRM
9.	The OTHERS Exception Handler
10.	Error-handling features of PL/SQL: log exception
11.	PLS-483 error: Duplicate Handlers
12.	NO_DATA_FOUND exception.
13.	The scope of exceptions.
14.	Sub block in exception section
15.	Catch all exceptions
16.	Catch user-defined exception
17.	Check zero divide exception
18.	Combines declaring an EXCEPTION variable
19.	Insert error message to a table in exception handler
20.	Mapping a user-defined error code to an EXCEPTION variable
21.	This script demonstrates the EXCEPTION_INIT pragma.
22.	Error Handling Call
23.	Raise exception in if statement

Deal with multiple exception branches : Exception Handle « PL SQL « Oracle PL / SQL

Related examples in the same category