Error "Exception of PlanObj.toXML" when trying to get plan from a query that contains #2 (4269842)

Chatee ahora con Soporte

Regresar

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Título

Error "Exception of PlanObj.toXML" when trying to get plan from a query that contains #2
Descripción

Error "Exception of PlanObj.toXML" is returned when trying get an Explain plan for a query which has a variable pointing to CHR(2)
Causa

This is due to a bug in SQL Optimizer for Oracle when trying to build the XML for data that contains the #2 character.
Resolución

WORKAROUND:
Replace the CHR(2) variable with another literal string
STATUS:
Waiting for fix in a future release of SQL Optimizer for Oracle
ID de defecto

ST96867

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Contenido recomendado

Título