My Oracle Support Banner

User Parameter Value is Not Passed As Null In Correct Place to CGICMD.dat File When Being Passed Directly from URL (Doc ID 472320.1)

Last updated on MAY 03, 2023

Applies to:

Oracle Reports Developer - Version 10.1.2.0.2 and later
Oracle Forms for OCI - Version 12.2.1.4.0 and later
Information in this document applies to any platform.
This problem can occur on any platform.
This happens when using Cgicmd.dat file.

Symptoms

 

Using cgicmd.dat to run a report with parameters on the web. For example, you have a report sample.rdf with two parameters, P_1 and P_2. The cgicmd.dat entry for your report is as follows:


Then you expect it to pass value 20 to parameter P_2 and let P_1 be null. However, the P_1 parameter "gets" the value "20" in this case.  You want to be able to pass in a null value in the correct order directly from URL.

This is not an issue when passing in values (null or otherwise) directly into parameter form, using paramform=yes and omitting the parameters from cgicmd.dat entry.

 

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
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.