Why is the table() operator not working?
create or replace type tmp_011040_t2 as
table of (JSON_OBJECT_T) NOT PERSISTABLE;
declare
l_objects tmp_011040_t2;
begin
l_objects := tmp_011040_t2();
l_objects.extend(1);
l_objects(l_objects.last) := JSON_OBJECT_T.parse('{"a":"1","b":"1"}');
l_objects.extend(1);
l_objects(l_objects.last) := JSON_OBJECT_T.parse('{"a":"2","b":"2"}');
for i in (select * from table(l_objects) ) loop -- ERROR!!!
null;
end loop;
end;
-- ORA-40573: Invalid use of PL/SQL JSON object type.
select * from table()
to do? Return a row perl_objects
element, each with 2 columns?