RETURN My_TABLE As MTable MY_TABLE;

CAST(MULTISET(
      -- SELECT ... select statement here
      ) AS My_TABLE) INTO MTable FROM DUAL;

   SELECT OBJ_My_Object( --Object definition
                            
                                    )
      BULK COLLECT INTO My_Table
      FROM
      (  
        -- SELECT ... select statement here
      )

SELECT  CAST(COLLECT(OBJ_My_Object(...)) AS OBJ_TBL_My_Object
  INTO  OBJ_TBL_My_Object_variable
  FROM
      (  
        -- SELECT ... select statement here
      )
/