Categories
- All Categories
- Oracle Analytics Learning Hub
- 23 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 233 Oracle Analytics News
- 45 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 87 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
How to perform function on a multiple value parameter?
Akash R
Rank 1 - Community Starter
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);
Tagged:
0
Answers
-
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.
0
