DECLARE v_number NUMBER(6, 2) := 100; v_region_id regions.region_id%TYPE;

v_region_name regions.region_name%TYPE;

BEGIN

SELECT region_id, region_name INTO v_region_id, v_region_name

FROM regions

WHERE region_id = 1;

DBMS_OUTPUT.PUT_LINE('Region: ' || v_region_id || ' is: ' || v_region_name); v_number := v_number / 0;

END;

1. Why would this display an error message?

2. Modify the block to handle the execpetion. Explain what will happen.