SQL Language (MOSC)

MOSC Banner

Getting ORA-22337: the type of accessed object has been evolved after adding attribute

edited Jul 9, 2014 5:00AM in SQL Language (MOSC) 4 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

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