Mega Code Archive
Deal with multiple exception branches
<![CDATA[
-- 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;
/
]]>