Ora 600 [Qmxptevlxpo2] On Select With extractValue In The Where Clause And _simple_view_merge=FALSE (Doc ID 1375473.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms


ORA 600 [qmxptEvlXPO2] while executing select statement that includes extractValue in the WHERE clause and parameter _simple_view_merge=FALSE

select
extract(object_value, '/s:securityClass/@targetNamespace','xmlns:s="http://xmlns.oracle.com/xs"'),
extract(object_value, '/s:securityClass/@name','xmlns:s="http://xmlns.oracle.com/xs"')
from XDB.XS$SECURITYCLASS where extractValue(object_value, '/s:securityClass/@mutable', 'xmlns:s="http://xmlns.oracle.com/xs"')=:1



Basically any SELECT with extractValue in the WHERE clause will generate the error

conn oe/oe
alter session set "_simple_view_merging"=FALSE;

SELECT warehouse_name, EXTRACTVALUE(e.warehouse_spec, '/Warehouse/Docks')
"Docks"
FROM warehouses e
WHERE warehouse_spec IS NOT NULL
ORDER BY warehouse_name;

-- Runs ok



This fails:

alter session set "_simple_view_merging"=FALSE;

SELECT warehouse_name, EXTRACTVALUE(e.warehouse_spec, '/Warehouse/Docks')
"Docks"
FROM warehouses e
WHERE EXTRACTVALUE(e.warehouse_spec, '/Warehouse/Docks')=3;

-- ORA-600 [qmxptEvlXPO2]

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