My Oracle Support Banner

Unable To Pass Multiple Paramters To BI Report From Oracle Forms (Doc ID 2515634.1)

Last updated on APRIL 25, 2023

Applies to:

Oracle Forms - Version 12.2.1.3.0 and later
Oracle Forms for OCI - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

Passing two parameters to BI report from oracle Forms [64 Bit] Version 12.2.1.3.0.  The report accepts the values of the first parameter but not the 2nd or any following.

Sample Code is below

SET_REPORT_OBJECT_PROPERTY(PL_ID,BIP_REPORT_PARAMETERS,'P_FDATE='||:BLK_BIP.FROMDATE||CHR(10)||'P_TDATE='||:BLK_BIP.TODATE);

Note:  In order to pass more than one parameter to BI-Pub, you must include a new line feed CHR10 between each new parameter.

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.