PL/SQL: ORA-22905: cannot access rows from a non-nested table item
DECLARE
TYPE tr_invalid_pointers IS RECORD
(obj_name VARCHAR2(200)
,obj_type VARCHAR2(100)
,obj_parent VARCHAR2(100)
,obj_parent_type VARCHAR2(100)
,obj_id NUMBER
,obj_ver NUMBER
,installed_ver NUMBER
,definition_ver NUMBER
,company_id NUMBER
,ref_obj_id NUMBER
,work_area VARCHAR2(100)
,app_area VARCHAR2(100)
,domain VARCHAR2(100));
lr_invalid_pointers tr_invalid_pointers;
TYPE t_invalid_pointers IS TABLE OF tr_invalid_pointers
INDEX BY BINARY_INTEGER;
lt_invalid_pointers t_invalid_pointers;
BEGIN
-- populate lt_invalid_pointers;
insert into <<table>>
select SELECT obj_name,obj_type,obj_parent,obj_parent_type,obj_id,obj_ver,installed_ver