Categories
- All Categories
- 71 Oracle Analytics News
- 7 Oracle Analytics Videos
- 13.9K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 38 Oracle Analytics Trainings
- 57 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
How to pass multiple values to parameter
I am passing multiple values to parameter by using IN sql query it giving error of
ORA-00909: invalid number of arguments
whats the slution how to pass the values multple with parameter
Best Answer
-
@Abdur Rehman - From the provided screenshot, we can see that a list of values is being used. Could you please confirm if data is showing in the "Project Name" list of values?
Reference:
0
Answers
-
@Abdur Rehman Please refer Unable To Select Multiple Values For Parameter. Scheduled Job Fails With 'ORA-00909: invalid number of arguments' (Doc ID 2740185.1)
The document suggests to decrease the values till the error is resolved.
Please raise Enhancement request under otbi bip product.
1 -
yes list of values have value and this list of value is dependenton business unit parameter
0 -
@Abdur Rehman - In that case, please validate the dataset query by hardcoding multiple values as per your requirement into the SQL. Run the query directly on the database to check if it works. If it doesn't, then the issue is with the dataset query, which needs to be rewritten to handle multiple values selected through BIP parameters.
0 -
Hello Sumanth V -Oracle
i have run this query sperate data model and just use one parameter project name for whcih i have to do multiple selections its working fine by using just in clause in sql but when i am using t with business unit and project name is dependent on business unit its give error of invalid arguments
0 -
@Abdur Rehman - That does confirms the issue is with the SQL of data model. Kindly modify the same to handle multiple selections for failing parameters as well.
0