create or replace TYPE integer_array_type AS TABLE OF INTEGER;

create or replace PACKAGE BODY customer AS
    FUNCTION getall(p_Acct_Number INTEGER_ARRAY_TYPE, p_Site_Id INTEGER_ARRAY_TYPE) RETURN FULL_CUSTOMER_TYPE_T_T

final String func = "{? = call sdm.get_work_order_key(?,?)}";
final OracleCallableStatement call = (OracleCallableStatement) conn.prepareCall(func);
call.setInt(2, workOrderNumber);
call.setInt(3, siteId);
call.registerOutParameter(1, Types.INTEGER);
call.executeUpdate();

create or replace TYPE full_customer_type_t_t AS TABLE OF full_customer_type_t;

create or replace TYPE full_customer_type_t AS TABLE OF full_customer_type;

create or replace TYPE full_customer_type AS OBJECT
(
    --
    -- Customer Master
    --
    CUSTOMER_KEY                NUMBER(38),
    BILL_SYS_SITE_ID            NUMBER(3),
    ACCT_NO                     NUMBER(9),
    TITLE                       VARCHAR2(4),
    FIRST_NAME                  VARCHAR2(10),

   ... etc

);