Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Nested Table Alter Type

774098Dec 8 2010 — edited Jan 13 2011
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 10 2011
Added on Dec 8 2010
4 comments
760 views