How to perform function on a multiple value parameter?

Question

I'm trying to perform a function on parameter with multiple inputs oracle BI.

It's a LoV parameter where u can select multiple values.

It shows invalid number of arguments.

I want to do something like,

SELECT * FROM table

WHERE value IN LOWER(:Parameter);

Gianni Ceresa · Answer

Where are you writing that query in OBIEE?

The error message (probably ORA-00909: invalid number of arguments ) is your database telling you that you are passing too many arguments to LOWER, the function only take one single parameter, not a list of values.