Query with Datatype xmltype Gives an Error in Interactive Reporting (Doc ID 742750.1)

Last updated on MARCH 08, 2017

Applies to:

Hyperion BI+ - Version: 9.3.1.0.00 to 11.1.2.1.000 - Release: 9.3 to 11.1
Hyperion BI+ - Version: 9.0.0.0.00 to 11.1.2.1.000   [Release: 9.0 to 11.1]
Information in this document applies to any platform.
Interactive Reporting does not support the XMLTYPE datatype of the Oracle database. This was raised as CR enhancement 1-225755230, but was not carried across to the Oracle bug system as there are no plans for supporting XML fields.

Symptoms

Server Error [1012]: Unknown error detected while retrieving next query results.

Changes

There was some talk about SQR/Production Reporting 11.x support for Microsoft Windows only (not Unix/Linux) DataDirect ODBC support for XML...but it has not appeared in the certification matrices up through SQR 11.1.2.1. EPM 11.1.2.1 does not bundle XML ODBC drivers for any Reporting and Analysis applications. 

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