create or replace 
  type CASES_TYPE_N IS object(
    CASEID VARCHAR2(128),
    FirstNumber VARCHAR2(32),
    DLR number[color=blue][/color]
  );

create or replace 
TYPE CASES_TABLE_N AS TABLE OF CASES_TYPE_N;

create or replace 
PACKAGE BANKRUPT_TEST AS 
  procedure BANKRUPT_TEST_p(
                           pType            in integer,
                           pRequestDate         in varchar2,
                           CasesList_1      out CASES_TABLE_N,
                           ResultCode       out integer,
                           ErrorText        out varchar2);

END BANKRUPT_TEST;

 create or replace
    PACKAGE BODY BANKRUPT_TEST AS
      procedure BANKRUPT_TEST_p(
                               pType              in integer,
                               pRequestDate     in varchar2,
                               CasesList_1          out CASES_TABLE_N,
                               ResultCode       out integer,
                               ErrorText        out varchar2) AS
      BEGIN 
        ResultCode := pType;
        ErrorText  := pRequestDate;

        select CASES_TYPE_N(CaseID,
                          FirstNumber,
                          dlr 
                     ) bulk collect
                  into CasesList_1
              from ( select
                        'CaseID' as CaseID,
                        'Fnum' as FirstNumber,
                        15 as dlr 
                      from dual
                  )
          ;
        NULL;

      END BANKRUPT_TEST_p;

    END BANKRUPT_TEST;