$1.$ A new part$-$time programming employee has been reviewing some PL$/$SQL code you devel$-$

oped. The following two blocks contain a variety of exception handlers. Explain the different

types for the new employee.

Block $1$:

DECLARE

ex$\_$prod$\_$update EXCEPTION;

BEGIN

UPDATE bb$\_$product

SET description $=$ 'Mill grinder with $5$ grind settings!$\text{'}$

WHERE idProduct $=30$;

IF SQL$\%$NOTFOUND THEN

RAISE ex$\_$prod$\_$update;

END IF;

EXCEPTION

WHEN ex$\_$prod$\_$update THEN

DBMS$\_$OUTPUT.PUT$\_$LINE$(\text{'}$Invalid product ID entered'$)$;

END;

Block $2$:

DECLARE

TYPE type$\_$basket IS RECORD

$($basket bb$\_$basket.idBasket$\%$TYPE,

created bb$\_$basket.dtcreated$\%$TYPE,

qty bb$\_$basket.quantity$\%$TYPE,

sub bb$\_$basket.subtotal$\%$TYPE$)$;

rec$\_$basket type$\_$basket;

lv$\_$days$\_$num NUMBER$(3)$;

lv$\_$shopper$\_$num NUMBER$(3)$ :$=26$;

BEGIN

SELECT idBasket, dtcreated, quantity, subtotal

INTO rec$\_$basket

FROM bb$\_$basket

WHERE idShopper $=$ lv$\_$shopper$\_$num

AND orderplaced $=0$;

lv$\_$days$\_$num :$=$ SYSDATE $-$ rec$\_$basket.created;

EXCEPTION

WHEN NO$\_$DATA$\_$FOUND THEN

DBMS$\_$OUTPUT.PUT$\_$LINE$(\text{'}$You have no saved baskets!$\text{'})$;

WHEN OTHERS THEN

DBMS$\_$OUTPUT.PUT$\_$LINE$(\text{'}$A problem has occurred.$\text{'})$;

DBMS$\_$OUTPUT.PUT$\_$LINE$(\text{'}$Tech Support will be notified and

will contact you via e$-$mail.$\text{'})$;

END;