$($Marks: $14)$

Question $5$

Consider the following PL$/$SQL query:

SET ServerOutputs on

DECLARING

doctor$\_$name varchar$2(50)$;

CURSER c$1$ IS SELECT d$.$firstname $1{|}^{\text{'}\text{'}}|$ d$.$surname DOCTOR

FROM doctor $d,$ medicine $m,$ prescription $p$

where $d.$doctorid $=p.$doctorid

and $m.$medid $=p.$medid

and $p.$quantity $=1$;

BEGIN

OPEN C$1$;

LOOP

FETCH cur$1$ INTO doctor$\_$name;

EXIT WHEN $1\%$ NOTFOUND;

dbms$\_$output.put$\_$line$(\text{'}$DOCTOR: $\text{'}+$d$\_$name $)$;

END;

END;

Q$\mathrm{.}5\mathrm{.}1$ The code above has seven $(7)$ errors. Identify the errors and rewrite the code so

$(14)$

that it would produce a valid output.