How do I call this procedure in a anonymous block?

 

create or replace PROCEDURE DEPT_EMPLOYEE_DETAILS

IS

CURSOR C_DETAILS

IS

 select d.department_id AS Department_id,

         d.department_name AS department_name,

         d.manager_id AS manager_id,

         e.employee_id AS employee_id,

         e.first_name || ' ' || e.last_name AS full_name

 from   departments d, employees e

 where e.department_id = e.department_id;

 

R_DETAILS C_DETAILS%ROWTYPE;

 

BEGIN

 OPEN C_DETAILS;

 FETCH C_DETAILS into R_DETAILS;

 

 DBMS_OUTPUT.PUT_LINE('----------------------');

 

 LOOP

   DBMS_OUTPUT.PUT_LINE('Department Id: ' || r_details.Department_id);

   DBMS_OUTPUT.PUT_LINE('Department Name: ' || r_details.department_name);

   DBMS_OUTPUT.PUT_LINE('Department Manager: ' || r_details.manager_id);

   DBMS_OUTPUT.PUT_LINE('Employee Id: ' || r_details.employee_id);

   DBMS_OUTPUT.PUT_LINE('Employee Full Name: ' || r_details.full_name);

 

 EXIT WHEN C_DETAILS%NOTFOUND;

 END LOOP;

 

 DBMS_OUTPUT.PUT_LINE('----------------------');

 

 EXCEPTION

 WHEN NO_DATA_FOUND THEN

      DBMS_OUTPUT.PUT_LINE('No data found');

END;

APlusGrades

Not Rated (0)

Status NEW Posted 16 Jul 2017 07:07 AM My Price 11.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- Â-----------  -----------Tha-----------nk -----------you----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------.Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m Â----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I

Not Rated(0)

• Buy Answer