Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 39 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 276 Oracle Analytics and AI News
- 50 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 102 Oracle Analytics and AI Trainings
- 17 Oracle Analytics and AI Challenge
- 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
