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;

SophiaPretty

(5)

Status NEW Posted 29 Nov 2017 01:11 PM My Price 7.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)

• Buy Answer