How to pass multiple values to parameter

Abdur Rehman

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

Sumanth V -Oracle

@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: https://docs.oracle.com/middleware/1221/bip/BIPDM/add_params_lovs.htm#CIHHICAF

Ram-Oracle

@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.

Abdur Rehman

Sumanth V -Oracle

yes list of values have value and this list of value is dependenton business unit parameter

Sumanth V -Oracle

@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.

Abdur Rehman

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

Sumanth V -Oracle

@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.