Getting ORA-22337: the type of accessed object has been evolved after adding attribute
Hi Experts,
After adding attribute SQL query fails with ORA-22337. Not sure whether any steps are missing. Thank you
Attached test case to reproduce the error
DB Version : 11.2.0.1
SQL> conn t_user/test
Connected.
SQL>
SQL>
SQL>
SQL> create or replace type tns_nodes_row is object (host varchar2(30), port number(10), protocol varchar2(20)) ;
2 /
Type created.
SQL>
SQL> create or replace type tns_addr_list is table of tns_nodes_row ;
2 /
Type created.
SQL>
SQL> desc TNS_NODES_ROW
Name Null? Type
----------------------------------------- -------- ----------------------------
HOST VARCHAR2(30 CHAR)
PORT NUMBER(10)
PROTOCOL VARCHAR2(20 CHAR)
SQL> desc TNS_ADDR_LIST
TNS_ADDR_LIST TABLE OF TNS_NODES_ROW