Error using Rewrite option for query having an XML "extract" function: "The Parser did not identi (4222706)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Error using Rewrite option for query having an XML "extract" function: "The Parser did not identi
Description

Following error occurs using Rewrite option for query having an XML "extract" function: "The Parser did not identify the text as a valid SQL statement.”
rtrim(xmlagg(xmlelement(e, ename || ',')).extract('//text()').extract('//text()') ,',')
Resolution

WORKAROUND:
None
STATUS:
Waiting for fix to be released in a future version of Quest SQL Optimizer for Oracle.
Defect ID

ST 91701

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title