1 Reply Latest reply: Apr 11, 2013 12:37 PM by clcarter RSS

    sum error accure follow query any one support me

    1002565
      create or replace package hr.pkg_report_emp
      as
      type ref_report is ref cursor;
      procedure pro_report(p_dep_id number,out_ref_report out ref_report);
      end pkg_report_emp;
      /





      create or replace package hr.pkg_report_emp
      is
      procedure pro_report(p_dep_id number,out_ref_report out ref_report);
      is
      begin
      open out_ref_report for
      select * from EMPLOYEES e,DEPARTMENTS d,LOCATIONS l,JOB_HISTORY h
      where e.department_id=d.department_id
      and l.location_id=d.location_id
      and h.employee_id=e.employee_id
      and d.department_id=p_dep_id;
      end;
      end pkg_report_emp;
      /

      Edited by: 999562 on 11 Apr, 2013 9:19 AM