Hi,
I try to use table() function over collection of rows. It fails in delete statements (delete MY_TABLE where xxx in (select yyy from table(collection)). When I use the same construction in select statement it works fine. Same issue exists for update statements. It looks like a obvious Oracle bug.
My test case -

create table Z_TEST (
id integer,
val varchar2(10)
);

create or replace package ZPKG1 as
type ZTestColl is table of Z_TEST%rowtype;
procedure test;
end;
/

create or replace package body ZPKG1 as
tab1 ZTestColl := ZTestColl();

procedure test as
c integer;
begin
dbms_output.put_line('testing select from table()');
select count(*) into c from table(tab1);
dbms_output.put_line('testing select from .. where id in (select id from table())');
select count(*) into c from Z_TEST where id in (select id from table(tab1));
dbms_output.put_line('testing delete from .. where id in (select id from table())');
delete from Z_TEST where id in (select id from table(tab1));
exception when others then
dbms_output.put_line(sqlerrm);
end;
end;
/

exec zpkg1.test;

Output is
testing SELECT from table()
testing SELECT from .. where id in (select id from table())
testing DELETE from .. where id in (select id from table())
ORA-00902: invalid datatype