REPORT CALLS FROM FORMS WITH PARAMETER CONTAINING COMMA OR DELIMITED VALUE OR QUOTE FAILS IN 11g (Doc ID 2023461.1)

Last updated on JULY 22, 2015

Applies to:

Oracle Reports Developer - Version 11.1.1.3.0 to 11.1.2.2.0 [Release 11g]
Oracle Forms - Version 11.1.1.3.0 to 11.1.2.2.0 [Release 11g]
Information in this document applies to any platform.

Symptoms

Oracle FMW Forms & Reports 11g Release 1 & 11g Release 2

The issue can be reproduced with the following code in the form:

Case 1

Pass parameter using SET_REPORT_OBJECT_PROPERTY(rep_id, REPORT_OTHER, 'p_test=''''PARAM1'',''PARAM2''''');
Result: This request fails because either RUN_REPORT_OBJECT or Report Services removes the quotes surrounding 'PARAM1'',''PARAM2'

Case 2

Pass parameter using SET_REPORT_OBJECT_PROPERTY(lrep_id, REPORT_OTHER, 'p_test=''''PARAM WITH SPACE'',''PARAM2''''');
Result: This request is successful because of the space in the parameter.

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