ORA-00907: missing right parenthesis https://docs.oracle.com/error-help/db/ora-00907/

Sushant95-Oracle

Hi Folks,

One of our client requirement is to develop an "An audit report for Requisition", we develop the report but facing issue while adding parameters in the query , the objective is to allow "Multiple Requisition Number and Last Update Date" parameter in the report, but we get this following error while adding the parameter.

"ORA-00907: missing right parenthesis https://docs.oracle.com/error-help/db/ora-00907/"

"and IRB.REQUISITION_NUMBER in (:p_REQUISITION_NUMBER) IS NULL OR IRB.REQUISITION_NUMBER =:p_REQUISITION_NUMBER"

The query contains multiple UNIONS.

Please assist.

Gianni Ceresa

and IRB.REQUISITION_NUMBER in (:p_REQUISITION_NUMBER) IS NULL 

OR IRB.REQUISITION_NUMBER =:p_REQUISITION_NUMBER

You have to decide: it's either a IN condition or a IS NULL condition, you can't have a IN … IS NULL.

If you look at the full query, you should easily see what makes it invalid, it's just SQL…

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/25571/ora-00907-missing-right-parenthesis-https-docs-oracle-com-error-help-db-ora-00907

Hi @Sushant95-Oracle,

Please try the following way to see if there's any betterment.

and (
IRB.REQUISITION_NUMBER in (:p_REQUISITION_NUMBER) IS NULL 
OR IRB.REQUISITION_NUMBER =:p_REQUISITION_NUMBER
)

Hope this help.

Thank you.

Sushant95-Oracle

Still getting the same error.

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/67213#Comment_67213

You have to do it for all the prompts that you are using if you are using similar query for others too.

If possible attach your catalog here so that we will try to replicate in our instance and which will be helpful to get a potential resolution.

Thank you.