Database Software

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!

ORA-01732 data manipulation operation not legal on this view

111691Aug 2 2002

Hi! I'm tring to update nested table collection(sgp_item) item:

update "spec_tbl" t set value(t)=
updatexml( value(t),'/spec/sgp_item[0]/sgp_qty', 3)
where existsnode( value(t),'/spec[el_name="aaaaaaaaaa"]')=1;

and I've got something about view(ORA-01732) but no views exists in my database at all- spec_tbl
is xml table.
What's the matter?

Thank you.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 30 2002

Added on Aug 2 2002

#performance-availability, #xml-db

0 comments

500 views