Query executes correctly and explain plan display correctly in both Toad and SQLPlus but receive syntax error when SQL Optimizer attempts to run explain plan or execute the SQL.
"The Parser did not identify the text as a valid SQL statement."
"ORA-19224: XPTY0004 - XQuery static type mismatch: expected - node()* got - xs:string
Invalid SQL statement. Verify that you have selected the right schema.
Only one SQL statement can be optimized in this window.
To analyze PL/SQL code or multiple SQL statements use the SQL Scanner."
Issue with parser not recognizing XML Table type.
WORKAROUND:
None
STATUS:
Waiting for fix in a future version of SQL Optimizer for Oracle.
