DECLARE

TYPE R_WA IS RECORD
(
v_id        au.id%type,
v_usuario   au.user%type,
v_ticket    au.ticket%type
);

TYPE T_WA IS TABLE OF R_WA;

V_WA T_WA;

BEGIN

select id, user, ticket
bulk collect into v_wa
from au;

END;

select id, user, ticket
into v_wa
from au;

select id, user, ticket
bulk collect into v_wa
from au;

DECLARE
    TYPE R_WA IS RECORD(
                        v_id        emp.empno%type,
                        v_usuario   emp.ename%type,
                        v_ticket    emp.job%type
                       );
    TYPE T_WA IS TABLE OF R_WA;
    V_WA T_WA;
BEGIN
    select  empno,
            ename,
            job
      bulk  collect
      into  v_wa
      from  emp
      where rownum = 1;
END;
/

PL/SQL procedure successfully completed.

SCOTT@orcl > 

SCOTT@orcl > DECLARE
  2      TYPE R_WA IS RECORD(
  3                          v_id        emp.empno%type,
  4                          v_usuario   emp.ename%type,
  5                          v_ticket    emp.job%type
  6                         );
  7      TYPE T_WA IS TABLE OF R_WA;
  8      V_WA T_WA;
  9  BEGIN
 10      select  empno,
 11              ename,
 12              job
 13  --      bulk  collect
 14        into  v_wa
 15        from  emp;
 16  END;
 17  /
      into  v_wa
            *
ERROR at line 14:
ORA-06550: line 14, column 13:
PLS-00642: local collection types not allowed in SQL statements
ORA-06550: line 15, column 7:
PL/SQL: ORA-00947: not enough values
ORA-06550: line 10, column 5:
PL/SQL: SQL Statement ignored


SCOTT@orcl >