title: Insert into table from collection type oracle 12c - ORA-00902: invalid datatype
body: <p>I am using Oracle 12.1 I thought I can query the table types in 12c.I get error ORA-00902: invalid datatype when I try to execute this package.
  I even tried using cast multiset,but still same error.</p>
  
  <p>I know we can create object at database level and then query, but I don't want to.</p>
  
  <pre><code>CREATE OR REPLACE PACKAGE test123 AS
   TYPE typ1 IS RECORD(col1 VARCHAR2(100),col2 VARCHAR2(100));
   TYPE tab_typ IS TABLE OF typ1 INDEX BY BINARY_INTEGER;
  v_tab tab_typ;
  
  PROCEDURE p1;
  END;
  /
  CREATE OR REPLACE PACKAGE BODY test123 AS
  
  PROCEDURE p1 IS
   BEGIN
    SELECT c1,c2 BULK COLLECT INTO v_tab FROM tabx;            
     INSERT INTO taby
       SELECT * FROM TABLE(v_tab);
    END;
  END;
  /
  
  EXEC test123.p1;
  --ORA-00902: invalid datatype
  </code></pre>