Could you please let us know the possible causes of below error in the ppm report perspective. We have created a report and we have a multi-select report filter that when exceed to more that 30 values gives the error -->
The maximum parameter length for SqlPlus is 239 characters.
Eric may be right. Though, the report submissions are saved to a database table and only the paramter columns 46 - 50 allow 4000 characters, so you should make sure, for the filter in question, to use parameter46 or higher.
30 resources seems about right - for each selected resource you're sending a 5-digit resource_id and probably the 3-char #@# delimiter. This will add up fast.
When the error refers to "Parameter #11" it means the eleventh parameter passed to sqlplus, not parameter11 in your report.
I don't know of any option to increase the max size for a sqlplus parameter, so I think you will have to limit the report to less than 30 resources, or possibly find a workaround like creating a JSP report or using multiple fields to select all the resources your report requires. Is this an OOB report?
the parameter#11 refers to the 10th parameter I am passing in the sql. I have tried moving my parameter11 to the end..19th parameter, and the error shows parameter#20, the error message varies in the current+1 position of the exceeded parameter.