Statement st = con.createStatement();
            ResultSet res = st.executeQuery("{call lspGetDataDec('"+dateSelected+"',"+areaID+")}");
             while (res.next()) {
                dbObj = new DBObjBaseStd();
                dbObj.setDecision1(res.getString("decision1"));
                dbObj.setDecision2(res.getString("decision2"));
                dbObj.setDecision3(res.getString("decision3"));
                dbObj.setDecision4(res.getString("decision4"));
....

create function test_cursor 
            return sys_refcursor
            is
                    c_result sys_refcursor;
            begin
                    open c_result for
                    select * from dual;
                    return c_result;
            end;

CREATE OR REPLACE 
PACKAGE my_PKG AS 

  TYPE rcd_getRows IS RECORD(
    l_a myTable.a%TYPE,
    l_b myTable.b%TYPE,
    l_c myTable.c%TYPE,
  );
  
  TYPE tbl_tableName  IS TABLE OF rcd_getRows;
  
  FUNCTION fnc_getRows (prm_1 myTable.a%TYPE DEFAULT NULL) RETURN tbl_tableName  pipelined;

END my_PKG;

CREATE OR REPLACE
PACKAGE BODY my_PKG AS

FUNCTION fnc_getRows (prm_1 myTable.a%TYPE DEFAULT NULL) RETURN tbl_tableName  
 pipelined AS
 BEGIN
 for curr in
 (
 SELECT * FROM sourceTable
 ) loop
 pipe row (curr);
 end loop;
  END fnc_getRows;

END my_PKG

SELECT * FROM TABLE(my_PKG.fnc_getRows);