String strCall = "{?= call rowtypes.f_char() }";
 calWork = cnn.prepareCall(strCall);
 calWork.registerOutParameter(1, OracleTypes.PLSQL_INDEX_TABLE);
 calWork.execute();

  String strSql = "select * from table(rowtypes.f_pipe)";
  OracleStatement stmt = (OracleStatement) cnn.createStatement();
  OracleResultSet rsWork = (OracleResultSet) stmt.executeQuery(strSql);

create or replace package rowtypes is
  cursor cur is
    select * from employees;
  type tbl is table of cur%rowtype;
  function f_pipe return tbl
    pipelined;
  function f_char return varchar2;
end;
/

create or replace package body rowtypes is
  function f_char return varchar2 is
  begin
    return 'TEXT';
  end; 
  function f_pipe return tbl pipelined is
  begin
    for rec in cur loop 
      pipe row(rec);
    end loop;
  end;
end;
/

calWork.registerOutParameter(1, OracleTypes.CURSOR);

java.sql.SQLException: ORA-06550: line 5, column 12:
PLS-00653: aggregate/table functions are not allowed in PL/SQL scope
ORA-06550: line 1, column 22:

CallableStatement

OracleStatement

create or replace package rowtypes is
  cursor cur is
    select * from employees;
  type tp_row is record(
    account  varchar2(10),
    sum_nach number(10, 2),
    sum_upl  number(10, 2));
  type tp_tbl is table of tp_row;

  function f_pipe return tp_tbl
    pipelined;
  function f_char return varchar2;
end;
/

create or replace package body rowtypes is
  function f_char return varchar2 is
  begin
    return 'TEXT';
  end;
  function f_pipe return tp_tbl
    pipelined is
    v_tbl  tp_tbl;
    type tp_tbl_index is table of varchar2(10) index by pls_integer;
    v_tbl_index tp_tbl_index;
    v_indx varchar2(10);
    v_row  tp_row;
  begin
    select * bulk collect
      into v_tbl
      from (select 1006 f_accoun, 0 f_nach, 0 f_upl
              from dual
            union all
            select 1008, 0, 0 from dual) v;
    v_indx:=v_tbl.first;
    while v_indx is not null loop
          v_tbl_index(v_tbl(v_indx).account):=v_indx;
          v_indx:=v_tbl.next(v_indx);  
    end loop;            
    v_tbl(v_tbl_index('1006')).sum_nach := 106.01;
    v_tbl(v_tbl_index('1008')).sum_nach := 108.02;
    v_tbl(v_tbl_index('1006')).sum_upl := 96.01;
    v_tbl(v_tbl_index('1008')).sum_upl := 98.01;
    v_indx := v_tbl.first;
    while (v_indx is not null) loop
      v_row := v_tbl(v_indx);
      pipe row(v_row);
      v_indx := v_tbl.next(v_indx);
    end loop;
    dbms_session.free_unused_user_memory;
    return;
  end;
end;
/

Сумма отклонений = Сальдо по дебету 16-го счета на начало месяца
+ Оборот по дебету 16-го счета за месяц х Оборот по кредиту 10-го (41) счета за месяц

Сальдо по дебету 10-го (41) счета на начало месяца + Оборот по дебету 10-го (41) счета за месяц