Tom
I have created a procedure prc_pass_array in a package named pkg_test. The procedure has only one parameter and it is out parameter. The parameter holds the employee id list.

Now when i called that procedure it gives error.
Note: parameter's data type is user defined type.

--the package is
CREATE OR REPLACE PACKAGE pkg_test IS
TYPE v_array IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
PROCEDURE prc_pass_array(p_empid OUT v_array);
END;
/
CREATE OR REPLACE PACKAGE BODY pkg_test IS
PROCEDURE prc_pass_array(p_empid OUT V_ARRAY) IS
BEGIN
SELECT employee_id BULK COLLECT INTO p_empid FROM EMPLOYEES;
END;
END;
/

--and the calling is
DECLARE
TYPE v_array IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
v_empid v_array;

v_emp NUMBER;
BEGIN

PKG_TEST.prc_pass_array(V_empid);
FOR i IN v_empid.first..v_empid.last LOOP
DBMS_OUTPUT.PUT_LINE(v_empid(i));
END LOOP;
END;


--but the following block works
DECLARE
TYPE array_string IS TABLE OF VARCHAR2(50);
v_empid ARRAY_STRING;
BEGIN
SELECT employee_id BULK COLLECT INTO v_empid FROM EMPLOYEES;

FOR i IN v_empid.first..v_empid.last LOOP
DBMS_OUTPUT.PUT_LINE(v_empid(i));
END LOOP;
END;
/


could you please give me the solution(with explanation) for this.

DECLARE 
  v_empid <b>PKG_TEST.</b>v_array; 
  
  v_emp NUMBER; 
BEGIN 
  
  PKG_TEST.prc_pass_array(V_empid); 
  FOR i IN v_empid.first..v_empid.last LOOP 
    DBMS_OUTPUT.PUT_LINE(v_empid(i)); 
  END LOOP; 
END;