BIP Report Multi-select Optional Parameter Gets ORA-00920
(Doc ID 1916578.1)
Last updated on AUGUST 11, 2022
Applies to:BI Publisher (formerly XML Publisher) - Version 126.96.36.199.0 to 188.8.131.52.x [Release 11.1]
Information in this document applies to any platform.
There are reports with multi-select parameters and some of them optional parameters. When the List Of Values (LOV) contains 3000 or
more records, not all values can be passed so, in the where statement, used the null value passing with the multi-select:
AND (XXMC_MAL_V.TAMCN IN (:P_TAMCN) )
However, this gets an error:
ORA-00920: invalid relational operator
Changed the where statement to:
AND (XXMC_MAL_V.TAMCN IN (:P_TAMCN) OR :P_TAMCN IS NULL)
However, still get the same error.
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