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 11.1.1.9.170718 and later
Information in this document applies to any platform.

Symptoms

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:

<reportParams>
  <variables>
    <name><variable_name></name>
    <value xsi:type="xsd:string" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><variable_value></value>
  </variables>
</reportParams>

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?

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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