Ora-00600 [Qerocpfetch1] On Updatexml After Applying Patch 9577552 (Doc ID 1102685.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms


The Following UPDATE generates ORA-600 after applying <<Patch 9577552>>

UPDATE table_xml
SET column_xml =
UPDATEXML(column_xml, '/OfferRate/RateStatus/text()', 'Sent')
WHERE extractValue(column_xml,'/OfferRate/AgreementID') = '00000150'
and extractValue(column_xml,'/OfferRate/RateStatus') = 'Incomplete'
AND extractValue(column_xml,'/OfferRate/RateID/text()') = '1'
/

UPDATE table_xml
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [qerocpFetch1], [2], [], [], [], [],
[], [], [], [], [], []

Before applying <<Patch 9577552>> the UPDATE returns error: ORA-01407: cannot update ("SCOTT"."TABLE_XML"."SYS_NC00008$") to
NULL
which is also incorrect.


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms