My Oracle Support Banner

SOAP Request With Apostrophe In ReportParams Generates Incorrect SQL (Doc ID 2435383.1)

Last updated on JUNE 09, 2020

Applies to:

Business Intelligence Suite Enterprise Edition - Version and later
Information in this document applies to any platform.


You are using the XMLViewService to obtain the results of analyses in XML format. You are using the ReportParams structure to set variables and filter the data:

    <value xsi:type="xsd:string" xmlns:xsi=""><variable_value></value>

And your <variable_value> includes an apostrophe in it (i.e. Oracle's).

When the query is executed the BIEE server is double escaping the value as seen on the obis component query log:

WHERE ((CAST(<column_name> AS varchar(30)) IN ('Oracle\''''s'))...

And the results are incorrect.

How can this be prevented?




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.