CREATE OR REPLACE FUNCTION GET_TAB(P_CURS SYS_REFCURSOR) RETURN TYP1_TAB PIPELINED IS
OUT_REC TYP1:=TYP1(NULL,NULL,NULL,NULL);
V_NAZWA VARCHAR2(5);
V_NUMER NUMBER;
 
 
BEGIN
 
LOOP
FETCH P_CURS INTO V_NUMER,V_NAZWA;
##########
And here i would like to return array or object with results and attribute them to out_rec type.
Something like that
V_results[]:= BIOJAVACLOB(v_NAZWA, v_NUMER);
out_rec.WYNIK1:= v_results[0];
out_rec.WYNIK2:=v_results[1];
out_rec.WYNIK3:=v_results[2];
...
##########
EXIT WHEN P_CURS%NOTFOUND;
END LOOP;
 
RETURN;
END;
/

Select wynik1,wynik2,wynik3,wynik4 etc.. from table(GET_TAB(select clob1, clob2 from table_name where id > 100 ));

SQL> create or replace type my_record is object (
  2    val1 varchar2(100),
  3    val2 varchar2(100),
  4    val3 varchar2(100),
  5    val4 varchar2(100))
  6  /

Type created.

SQL> create or replace type my_table is table of my_record
  2  /

Type created.

SQL> create or replace function BIOJAVACLOB (p1 clob, p2 clob)
  2  return sys.odcivarchar2list
  3  is
  4    l_val sys.odcivarchar2list := sys.odcivarchar2list();
  5  begin
  6    for i in 1..2 loop
  7      l_val.extend (2);
  8      l_val(2*i-1) := substr(p1, 10*(i-1)+1, 10);
  9      l_val(2*i)   := substr(p2, 10*(i-1)+1, 10);
 10    end loop;
 11    return l_val;
 12  end;
 13  /

Function created.

SQL> create or replace function get_tab (p_curs sys_refcursor)
  2  return my_table
  3  pipelined
  4  is
  5    l_v1  clob;
  6    l_v2  clob;
  7    l_val sys.odcivarchar2list;
  8  begin
  9    loop
 10      fetch p_curs into l_v1, l_v2;
 11      exit when p_curs%notfound;
 12      l_val := BIOJAVACLOB (l_v1, l_v2);
 13      pipe row (my_record(l_val(1),l_val(2),l_val(3),l_val(4)));
 14    end loop;
 15  end;
 16  /

Function created.

SQL> drop table t purge;

Table dropped.

SQL> col v1 format a20
SQL> col v2 format a20
SQL> create table t (id int, v1 clob, v2 clob);

Table created.

SQL> insert into t
  2  select level,
  3         rpad(chr(ascii('A')+2*(level-1)),10,chr(ascii('A')+2*(level-1)))||
  4           rpad(chr(ascii('A')+2*(level-1)+1),10,chr(ascii('A')+2*(level-1)+1)),
  5         rpad(chr(ascii('A')+2*level),10,chr(ascii('A')+2*level))||
  6           rpad(chr(ascii('A')+2*level+1),10,chr(ascii('A')+2*level+1))
  7  from dual
  8  connect by level <= 5
  9  /

5 rows created.

SQL> select * from t order by id;
        ID V1                   V2
---------- -------------------- --------------------
         1 AAAAAAAAAABBBBBBBBBB CCCCCCCCCCDDDDDDDDDD
         2 CCCCCCCCCCDDDDDDDDDD EEEEEEEEEEFFFFFFFFFF
         3 EEEEEEEEEEFFFFFFFFFF GGGGGGGGGGHHHHHHHHHH
         4 GGGGGGGGGGHHHHHHHHHH IIIIIIIIIIJJJJJJJJJJ
         5 IIIIIIIIIIJJJJJJJJJJ KKKKKKKKKKLLLLLLLLLL

5 rows selected.

SQL> col val1 format a10
SQL> col val2 format a10
SQL> col val3 format a10
SQL> col val4 format a10
SQL> select * from table(get_tab(cursor(select v1, V2 from t order by id)));
VAL1       VAL2       VAL3       VAL4
---------- ---------- ---------- ----------
AAAAAAAAAA CCCCCCCCCC BBBBBBBBBB DDDDDDDDDD
CCCCCCCCCC EEEEEEEEEE DDDDDDDDDD FFFFFFFFFF
EEEEEEEEEE GGGGGGGGGG FFFFFFFFFF HHHHHHHHHH
GGGGGGGGGG IIIIIIIIII HHHHHHHHHH JJJJJJJJJJ
IIIIIIIIII KKKKKKKKKK JJJJJJJJJJ LLLLLLLLLL

5 rows selected.

create or replace function BIOJAVACLOB (p1 clob, p2 clob)
  2  return sys.odcivarchar2list
  3  is
  4    l_val sys.odcivarchar2list := sys.odcivarchar2list();
  5  begin
  6    for i in 1..2 loop
  7      l_val.extend (2);
  8      l_val(2*i-1) := substr(p1, 10*(i-1)+1, 10);
  9      l_val(2*i)   := substr(p2, 10*(i-1)+1, 10);
 10    end loop;
 11    return l_val;
 12  end;
 13  /

create or replace function BIOJAVACLOB (p1 clob, p2 clob)
  2  return sys.odcivarchar2list
  3  is
  4    language java name 'demo.start(java.sql.clob,java.sql.clob) return Array/Object';
  5  end;
  6  /

	public static String[] start(...
		String[] myString = new String[]{a1,b1,c1};
						
		return myString;
		...

package demo;

public class Proba {

	public static String[] Start(String a1, String b1, String c1)
	{
		
		
		String[] myString = new String[]{a1,b1,c1};
		
		
		
		return myString;
		
	}
}

Create or replace TYPE array_type IS VARRAY(3) OF VARCHAR2(100);

Create or replace type my_record is object (
val1 varchar2(100),
val2 varchar2(100),
val3 varchar2(100));

create or replace function probna(p1 in VARCHAR2, p2 in VARCHAR2, p3 in VARCHAR2)
return array_type
is language java name 'demo.Proba.Start(java.lang.String,java.lang.String,java.lang.String) return java.lang.reflect.Array';

create or replace function probna2(item1 varchar2,item2 varchar2,item3 varchar2)
return my_table
pipelined
is
l_val array_type;
begin
l_val := probna(item1,item2,item3);
pipe row (my_record(l_val(1),l_val(2),l_val(3)));
end;

create or replace type my_table is table of my_record;

SQL> create or replace type STRING_ARRAY as table of VARCHAR2(255)
  2  /

Type created.

SQL> create or replace procedure BIOJAVACLOB (p1 clob, p2 clob, p3 out STRING_ARRAY)
  2  is
  3    language java
  4    name 'demo.start (oracle.sql.CLOB, oracle.sql.CLOB, oracle.sql.ARRAY[])';
  5  /

Procedure created.

SQL> create or replace and compile java source named "demo" as
  2    import java.io.*;
  3    import java.sql.*;
  4    import oracle.sql.*;
  5    import oracle.jdbc.driver.*;
  6
  7    public class demo extends Object {
  8      public static void start (oracle.sql.CLOB    p1,
  9                                oracle.sql.CLOB    p2,
 10                                oracle.sql.ARRAY[] p3)
 11      throws SQLException, IOException {
 12        Reader   is1      = p1.getCharacterStream();
 13        Reader   is2      = p2.getCharacterStream();
 14        String[] values   = new String[4];
 15        char     buffer[] = new char[10];
 16        int      length;
 17
 18        for ( int i = 0 ; i < 2 ; i++ ) {
 19          length = is1.read(buffer, 10*i, 10);
 20           values[2*i] = new String(buffer);
 21          length = is1.read(buffer, 10*i, 10);
 22           values[2*i+1] = new String(buffer);
 23        }
 24
 25        is1.close();
 26        is2.close();
 27
 28        Connection conn            = new OracleDriver().defaultConnection();
 29        ArrayDescriptor descriptor = ArrayDescriptor.createDescriptor ("STRING_ARRAY", conn);
 30        p3[0] = new ARRAY (descriptor, conn, values);
 31      }
 32    }
 33  /

Java created.

SQL> create or replace function get_tab (p_curs sys_refcursor)
  2  return my_table
  3  pipelined
  4  is
  5    l_v1  clob;
  6    l_v2  clob;
  7    l_val string_array := string_array();
  8  begin
  9    loop
 10      fetch p_curs into l_v1, l_v2;
 11      exit when p_curs%notfound;
 12      BIOJAVACLOB (l_v1, l_v2, l_val);
 13      pipe row (my_record(l_val(1),l_val(2),l_val(3),l_val(4)));
 14    end loop;
 15  end;
 16  /

Function created.

SQL> select * from table(get_tab(cursor(select v1, V2 from t order by id)));
VAL1       VAL2       VAL3       VAL4
---------- ---------- ---------- ----------
AAAAAAAAAA BBBBBBBBBB BBBBBBBBBB BBBBBBBBBB
CCCCCCCCCC DDDDDDDDDD DDDDDDDDDD DDDDDDDDDD
EEEEEEEEEE FFFFFFFFFF FFFFFFFFFF FFFFFFFFFF
GGGGGGGGGG HHHHHHHHHH HHHHHHHHHH HHHHHHHHHH
IIIIIIIIII JJJJJJJJJJ JJJJJJJJJJ JJJJJJJJJJ

5 rows selected.

create or replace type STRING_ARRAY as table of VARCHAR2(255)

String[] values   = new String[4];

create or replace type my_record is object (
one varchar2(4),
two number,
three number,
four float)
/
create or replace type STRING_ARRAY as table of my_record;
create or replace type my_table is table of my_record;

create or replace procedure BIOJAVACLOB (p1 clob, p2 clob, p3 out STRING_ARRAY)
 is
    language java
    name 'demo.start (oracle.sql.CLOB, oracle.sql.CLOB, oracle.sql.ARRAY[])';
 /

create or replace function get_tab (p_curs sys_refcursor)
    return my_table
    pipelined
    is
      l_v1  clob;
      l_v2  clob;
      l_val string_array := string_array();
    begin
      loop
      fetch p_curs into l_v1, l_v2;
       exit when p_curs%notfound;
       BIOJAVACLOB (l_v1, l_v2, l_val);
       pipe row (my_record(l_val(1),l_val(2),l_val(3),l_val(4)));
     end loop;
   end;
   /

create or replace and compile java source named "demo" as
      import java.io.*;
      import java.sql.*;
      import oracle.sql.*;
      import oracle.jdbc.driver.*;
  
      public class demo extends Object {
        public static void start (oracle.sql.CLOB    p1,
                                  oracle.sql.CLOB    p2,
                                 oracle.sql.ARRAY[] p3)
       throws SQLException, IOException {
         Reader   is1      = p1.getCharacterStream();
         Reader   is2      = p2.getCharacterStream();

         Object[] values   = new Object[3];

         values[0]=new String("aaa");
	 values[1]=new Integer(11);
	 values[2]=new Integer(22);
	 values[3]=new Double(111.1);
        
 
         is1.close();
         is2.close();
 
         Connection conn            = new OracleDriver().defaultConnection();
         ArrayDescriptor descriptor = ArrayDescriptor.createDescriptor ("STRING_ARRAY", conn);
         p3[0] = new ARRAY (descriptor, conn, values);
       }
     }
   /

create or replace type my_record is object (
one varchar2(4),
two number,
three number,
four double precision)
/

...
         values[0]=new String("aaa");
	 values[1]=new Integer(11);
	 values[2]=new Integer(22);
	 values[3]=new Double(111.1);

drop type STRING_ARRAY4;
drop type my_table4;
drop type my_record4;

create or replace type my_record4 is object (
      val1 varchar2(100),
      val2 varchar2(100),
      val3 number,
      val4 number(5));
    /
create or replace type my_table4 is table of my_record4;
    /

create or replace type STRING_ARRAY4 as table of VARCHAR2(255);
/
create or replace procedure BIOJAVACLOB4 (p1 clob, p2 clob, p3 out STRING_ARRAY4)
    is
      language java
      name 'demo4.start (oracle.sql.CLOB, oracle.sql.CLOB, oracle.sql.ARRAY[])';
    /
    create or replace and compile java source named "demo" as
      import java.io.*;
      import java.sql.*;
      import oracle.sql.*;
      import oracle.jdbc.driver.*;
  
      public class demo4 extends Object {
        public static void start (oracle.sql.CLOB    p1,
                                  oracle.sql.CLOB    p2,
                                 oracle.sql.ARRAY[] p3)
       throws SQLException, IOException {
         Reader   is1      = p1.getCharacterStream();
         Reader   is2      = p2.getCharacterStream();
         Object[] values   = new Object[4];

       values[0]=new String("aaaaaa");
       values[1]=new String("aaaaaa");
       values[2]=new Integer(100);
       values[3]=new Integer(101);
        
         is1.close();
         is2.close();
 
         Connection conn            = new OracleDriver().defaultConnection();
         ArrayDescriptor descriptor = ArrayDescriptor.createDescriptor ("STRING_ARRAY4", conn);
         p3[0] = new ARRAY (descriptor, conn, values);
       }
     }
   /
   
    create or replace function get_tab4 (p_curs sys_refcursor)
    return my_table4
    pipelined
    is
      l_v1  clob;
      l_v2  clob;
      l_val string_array4 := string_array4();
      l_v3 double precision;
    begin
      loop
       fetch p_curs into l_v1, l_v2;
       exit when p_curs%notfound;
       BIOJAVACLOB4 (l_v1, l_v2, l_val);      
       pipe row (my_record4(l_val(1),l_val(2),l_val(3),l_val(4)));
    end loop;
   end;
   /

drop type STRING_ARRAY4;
drop type my_table4;
drop type my_record4;

create or replace type my_record4 is object (
      val1 varchar2(100),
      val2 varchar2(100),
      val3 Double precision,
      val4 number(5));
    /
create or replace type my_table4 is table of my_record4;
    /

create or replace type STRING_ARRAY4 as table of VARCHAR2(255);
/
create or replace procedure BIOJAVACLOB4 (p1 clob, p2 clob, p3 out STRING_ARRAY4)
    is
      language java
      name 'demo4.start (oracle.sql.CLOB, oracle.sql.CLOB, oracle.sql.ARRAY[])';
    /
    create or replace and compile java source named "demo" as
      import java.io.*;
      import java.sql.*;
      import oracle.sql.*;
      import oracle.jdbc.driver.*;
  
      public class demo4 extends Object {
        public static void start (oracle.sql.CLOB    p1,
                                  oracle.sql.CLOB    p2,
                                 oracle.sql.ARRAY[] p3)
       throws SQLException, IOException {
         Reader   is1      = p1.getCharacterStream();
         Reader   is2      = p2.getCharacterStream();
         Object[] values   = new Object[4];

       values[0]=new String("aaaaaa");
       values[1]=new String("aaaaaa");
       values[2]=new Double(100.1);
       values[3]=new Integer(101);
        
         is1.close();
         is2.close();
 
         Connection conn            = new OracleDriver().defaultConnection();
         ArrayDescriptor descriptor = ArrayDescriptor.createDescriptor ("STRING_ARRAY4", conn);
         p3[0] = new ARRAY (descriptor, conn, values);
       }
     }
   /
   
    create or replace function get_tab4 (p_curs sys_refcursor)
    return my_table4
    pipelined
    is
      l_v1  clob;
      l_v2  clob;
      l_val string_array4 := string_array4();
      l_v3 double precision;
    begin
      loop
       fetch p_curs into l_v1, l_v2;
       exit when p_curs%notfound;
       BIOJAVACLOB4 (l_v1, l_v2, l_val);      
       pipe row (my_record4(l_val(1),l_val(2),l_val(3),l_val(4)));
    end loop;
   end;
   /

create table t5 (v1 clob,v2 clob);
insert into t5(v1,v2) values('aaaaaaaa','bbbbbbb');
select * from table(get_tab4(cursor(select v1, v1 from t5)));