rec1 sys_refcursor

select * from rec1

select * from TABLE(func(SYS_REF_CUR)) where ...

rec1 sys_refcursor;
select * from my_type(rec1);
--где my_type - мой тип с ODCI

      MEMBER FUNCTION ODCITableFetch(
                                     self   IN OUT REF_TABLE,
                                     nrows  IN     NUMBER,
                                     objSet OUT    SYS.ANYDATASET
                                   ) RETURN PLS_INTEGER
        IS
            elem_typ SYS.ANYTYPE;
        BEGIN
            SYS.ANYDATASET.BeginCreate(
                                       SYS.DBMS_TYPES.TYPECODE_OBJECT,
                                       tmt,
                                       objSet
                                      );
                objSet.Addinstance;
                objSet.PieceWise;
                LOOP
--                  objSet.SetNumber();
                  FETCH self.cur INTO self.sctx;
                  EXIT WHEN self.cur%NOTFOUND;
                  PIPE ROW(self.sctx);
                END LOOP;
                objSet.Endcreate;
            RETURN ODCICONST.SUCCESS;
      END;

CREATE OR REPLACE TYPE REF_TABLE
    AUTHID CURRENT_USER
    AS OBJECT(
              tmt        SYS.ANYTYPE,
              cur        SYS_REFCURSOR,
              STATIC FUNCTION ODCITableStart(
                                             sctx     IN OUT REF_TABLE,
                                             cur      IN SYS_REFCURSOR
                                            ) RETURN PLS_INTEGER,
              STATIC FUNCTION ODCITablePrepare(
                                               sctx     OUT REF_TABLE,
                                               tf_info  IN  SYS.ODCITabFuncInfo,
                                               cur      IN SYS_REFCURSOR
                                              ) RETURN PLS_INTEGER,
              MEMBER FUNCTION ODCITableFetch(
                                             self   IN OUT REF_TABLE,
                                             nrows  IN     NUMBER,
                                             objSet OUT    SYS.ANYDATASET
                                            ) RETURN PLS_INTEGER,
              MEMBER FUNCTION ODCITableClose(
                                             self IN REF_TABLE
                                            ) RETURN PLS_INTEGER,
              STATIC FUNCTION ODCITableDescribe(
                                                rtype    OUT SYS.ANYTYPE,
                                                cur      IN SYS_REFCURSOR
                                               ) RETURN PLS_INTEGER
             )