Oracle Analytics Publisher

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to pass multiple values to parameter

Accepted answer
267
Views
6
Comments
Abdur Rehman
Abdur Rehman Rank 1 - Community Starter

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

Answers

  • Ram-Oracle
    Ram-Oracle Rank 6 - Analytics Lead

    @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
    Abdur Rehman Rank 1 - Community Starter

    Sumanth V -Oracle

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

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    @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
    Abdur Rehman Rank 1 - Community Starter

    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
    Sumanth V -Oracle Rank 8 - Analytics Strategist

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