开发者

Oracle reports-Passing null parameters to RWRUN

开发者 https://www.devze.com 2023-03-07 10:09 出处:网络
I have a set of run-time parameters in the parameter form in oracle reports that have the \"Restrict List to predetermined values\". I am able to run the report in the report builder without supplying

I have a set of run-time parameters in the parameter form in oracle reports that have the "Restrict List to predetermined values". I am able to run the report in the report builder without supplying any value to these parameters. But during the batch run using RWRUN, I am getting the following warning and the report is not generated.

The value of restricted LOV parameter P_PARM1 is not among the selectable values

The above error occurs when I omit the parameter P_PARM1 altogether in the paramter list of RWRUN as well as when I supply it without giving any value to it(implying null) like below:

rwrun.sh <开发者_JAVA技巧other required parameters here> P_PARM1=

Any help would be much appreciated.


Does rwrun.sh ... P_PARM1='' yield anything different?

0

精彩评论

暂无评论...
验证码 换一张
取 消