declare
type anydata_t is table of (sys.anydata);
a anydata_t;
tp sys.anytype;
begin
a := anydata_t(
anydata.convertNumber(42),
anydata.convertVarchar2('hello world'),
anydata.convertDate(timestamp '2020-08-28 22:23:24')
);
for i in 1 .. a.count loop
dbms_output.put_line(
a(i).getTypeName || ' (' || a(i).getType(tp) || '): ' ||
--
a(i).accessNumber ||
a(i).accessVarchar2 ||
a(i).accessDate
);
-- if tp is null then
-- dbms_output.put_line('tp is null');
-- end if;
end loop;
end;
/