Error ORA-00904: "SYS"."ANYDATA"."CONVERTXMLTYPE": invalid identifier When Trying To Select XMLTYPE In Apex Components And Page Designer
(Doc ID 2466079.1)
Last updated on FEBRUARY 03, 2022
Applies to:Oracle Application Express (APEX) - Version 18.1 and later
Information in this document applies to any platform.
When a SQL query (in APEX component or within page designer) selects a plain XMLTYPE column (without converting to CLOB or VARCHAR2), this query fails with the following error message:
ORA-00904: "SYS"."ANYDATA"."CONVERTXMLTYPE": invalid identifier
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document