PL/SQL (MOSC)

MOSC Banner

PL/SQL: ORA-22905: cannot access rows from a non-nested table item

edited March 2012 in PL/SQL (MOSC) 9 commentsAnswered
Hi,

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center