Issuing Update Statement On Xmldb Table Gives Ora-01407 Error
(Doc ID 1092077.1)
Last updated on FEBRUARY 08, 2017
Applies to:Oracle Server - Enterprise Edition - Version: 126.96.36.199
Information in this document applies to any platform.
UPDATE TABLE_XML SET COLUMN_XML =
UPDATEXML(COLUMN_XML, '/OceanOfferRate/RateStatus/text()', 'Sent')
WHERE extractValue(COLUMN_XML,'/OceanOfferRate/AgreementID') = '1'
extractValue(COLUMN_XML,'/OceanOfferRate/ObjectID') = '1'
ERROR at line 1:
ORA-01407: cannot update ("SCOTT"."TABLE_XML"."SYS_NC00008$") to
Steps to reproduce:
1. Create directory
2. Register schemas
3. Create table
4. Create validation trigger
The error does not happen when the table is created without using VARRAY ... STORE AS TABLE
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|