Issuing Update Statement On Xmldb Table Gives Ora-01407 Error
(Doc ID 1092077.1)
Last updated on FEBRUARY 21, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
The statement throwing the error is:
UPDATE TABLE_XML SET COLUMN_XML =
UPDATEXML(COLUMN_XML, '/OceanOfferRate/RateStatus/text()', 'Sent')
WHERE extractValue(COLUMN_XML,'/OceanOfferRate/AgreementID') = '1'
and
extractValue(COLUMN_XML,'/OceanOfferRate/ObjectID') = '1'
/
UPDATEXML(COLUMN_XML, '/OceanOfferRate/RateStatus/text()', 'Sent')
WHERE extractValue(COLUMN_XML,'/OceanOfferRate/AgreementID') = '1'
and
extractValue(COLUMN_XML,'/OceanOfferRate/ObjectID') = '1'
/
ERROR at line 1:
ORA-01407: cannot update ("SCOTT"."TABLE_XML"."SYS_NC00008$") to
NULL
ORA-01407: cannot update ("SCOTT"."TABLE_XML"."SYS_NC00008$") to
NULL
Steps to reproduce:
1. Create directory
2. Register schemas
3. Create table
4. Create validation trigger
5. Insert
6. Update
The error does not happen when the table is created without using VARRAY ... STORE AS TABLE
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |