create or replace procedure test(p_deptno IN number,
                                 salary   OUT number,
                                 count    OUT number)is

  p_cursor sys_refcursor;

begin

  open p_cursor FOR 
  select *
  from   emp
  where  deptno = p_deptno;

  -- procedure to calculate total salary
  total_dept_salary(p_cursor, salary);
  
  -- procedure to calculate total head count in the department
  total_dept_count(p_cursor, cnt);

end test;

create or replace procedure test(p_deptno IN number,
                                 salary   OUT number,
                                 count    OUT number)is

  p_cursor sys_refcursor;
 
begin

  open p_cursor FOR 
  select *
  from   emp
  where  deptno = p_deptno;

  -- procedure to calculate total salary
  total_dept_salary(p_cursor, salary);

  open p_cursor FOR 
  select *
  from   emp
  where  deptno = p_deptno;
  
  -- procedure to calculate total head count in the department
  total_dept_count(p_cursor, cnt);

end test;

24374, 00000, "define not done before fetch or execute and fetch"
// *Cause:  The application did not define output variables for data being
//          fetched before issuing a fetch call or invoking a fetch by
//          specifying a non-zero row count in an execute call.
// *Action: Issue OCI define calls for the columns to be fetched.
bcm@bcm-laptop:~$ 

  open p_cursor FOR 
  select *
  from   emp
  where  deptno = p_deptno;