CREATE PRIVATE TEMPORARY TABLE ORA$PTT_TEST_TBL
  AS
    SELECT  *
      FROM  EMP
/
SET SERVEROUTPUT ON
DECLARE
    CURSOR V_CUR
      IS
    SELECT  D.DNAME,
            E.ENAME
      FROM  ORA$PTT_TEST_TBL E,
            DEPT D
      WHERE D.DEPTNO = E.DEPTNO;
BEGIN
    FOR V_REC IN V_CUR LOOP
      DBMS_OUTPUT.PUT_LINE(RPAD(V_REC.ENAME,11) || V_REC.DNAME);
    END LOOP;
END;
/

SMITH      RESEARCH
ALLEN      SALES
WARD       SALES
JONES      RESEARCH
MARTIN     SALES
BLAKE      SALES
CLARK      ACCOUNTING
SCOTT      RESEARCH
KING       ACCOUNTING
TURNER     SALES
ADAMS      RESEARCH
JAMES      SALES
FORD       RESEARCH
MILLER     ACCOUNTING

PL/SQL procedure successfully completed.

SQL>

create or replace TYPE stax_ask as object(
  id_ask number, p_6 varchar2(15), p_9 date, p_11 varchar2(20)
  );

create or replace type stax_task as table of  stax_ask; 

declare
 v_tt stax_task :=stax_task();
 begin
  v_tt.extend(2);
  v_tt(1):=stax_ask(10,null,null,null);
  v_tt(2):=stax_ask(20,null,null,null);
  for r in (select a.id_ask,d.dname from dept d,table(v_tt) a where d.deptno=a.id_ask) loop
   dbms_output.put_line(r.id_ask||' '||r.dname);
  end loop;
end;

10 ACCOUNTING
20 RESEARCH

Statement processed.