Transformar un xml en una tabla de objectos

xmltoobject.sql

create type t_flavio as object(c1 varchar2(100), c2 number);

create type t_flavio_c as table of t_flavio;

declare
  tabla t_flavio_c;
begin
with c1 as
(
select xmlelement("root", 
            xmlelement("rowset",
               xmlelement("row", xmlforest('12' as "c2", 222 as "c3")),
               xmlelement("row", xmlforest('12' as "c2", 444 as "c3")),
               xmlelement("row", xmlforest('12' as "c2", 555 as "c3")),
               xmlelement("row", xmlforest('12' as "c2", 666 as "c3"))
               )) x
from dual
)
select t_flavio(c2,c3) 
bulk collect into tabla 
from c1,xmltable('/root/rowset/row' 
                passing c1.x columns 
                    c2 varchar2(10) path 'c2',
                    c3 number path 'c3');
dbms_output.put_line(tabla.count);                    
end;