Nested Table Alter Type
774098Dec 8 2010 — edited Jan 13 2011Hi,
I am tying below query and I am getting this error. Please tell me the solution. I tried it in other database It worked fine. I have the permission to Alter the type in the database where I am getting error below.
SQL> ALTER TYPE WLINVESTMENTSUMMARY ADD ATTRIBUTE (OPENBALINUNITS NUMBER(35,2)) CASCADE;
ALTER TYPE WLINVESTMENTSUMMARY ADD ATTRIBUTE (OPENBALINUNITS NUMBER(35,2)) CASCADE FORCE
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-22914: DROP of nested tables not supported