SET serveroutput ON DECLARE — Declare the PL/SQL table TYPE deptarr IS TABLE OF dept%ROWTYPE INDEX BY BINARY_INTEGER; d_arr deptarr; — Declare cursor TYPE d_cur IS REF CURSOR RETURN dep…