1 .Select -> Object table (temp, тип TempType )
select cast(multiset(select * from MyTable) as TempType) into temp from dual;
 2 . Select -> REF CURSOR
open cur for
select * from MyTable
 3 . Object table -> REF CURSOR
open cur for
select * from table (cast(temp as TempType));
 4 . REF CURSOR -> Object table
?????

CREATE OR REPLACE TYPE IdRecType AS OBJECT (F_ID number);
GO
CREATE OR REPLACE TYPE IdTblType AS TABLE OF IdRecType;
GO

CREATE OR REPLACE FUNCTION FGetObjIdByObjDefId(ObjDefId IN number)
RETURN IdTblType
IS 
temp IdTblType;
BEGIN
SELECT CAST(MULTISET(SELECT F_OBJID FROM TObject 
WHERE F_OBJTYPEID = ObjDefId AND F_VERSION= 0 ) as IdTblType) INTO temp FROM dual;
RETURN(temp);
END;

select FGetObjIdByObjDefId( 23 ) from dual;

CREATE OR REPLACE PROCEDURE TestProc(Cur OUT CPack.TCursor)
AS 
temp IdTblType;
BEGIN
temp := FGetObjIdByObjDefId( 23 );
open Cur for
select a.* from TTable2 a
INNER JOIN temp b ON a.F_ID=b.F_ID;
END;

CREATE OR REPLACE PROCEDURE TestProc (Cur OUT CPack.TCursor)
AS
temp IdTblType;
BEGIN
temp := FGetObjIdByObjDefId( 23 );
open Cur for
select a.* from TAttr a
inner join table (cast(temp as IdTblType)) b ON a.F_ATTRID=b.F_ID;
END;