ORA 00907 Missing Right Parenthesis

Question

I am getting this Error of "Missing Right Parenthesis" on the Query below. Can someone rectify the mistake please?

SELECT 
    DESCRIPTION,
    TOTAL_ADMISSION,
    EMERGENCY,
    NORMAL      
  FROM TABLE (ORDERENTRY.PKG_S04REP00031.ADMISSION_SUMMARY(P_START_DATE = to_date('31/08/2021', 'dd/mm/yyyy')
                                                         P_END_DATE = to_date('01/09/2021', 'dd/mm/yyyy')
                                                         P_ADMISSION_TYPE    = 'NORMAL'
                                                         /*P_ORDER_LOCATION_ID => :P_ORDER_LOCATION_ID, */
                                                         P_LOCATION_ID = 'K01'));

Your code is not well formatted, bu it is easy to see that there are missing commas between the params, and in pl/sql you use -=> (as in the commented part, no = to specify the value after the parameter name. — gsalem

Roberto Hernandez Roberto Hernandez · Accepted Answer · 2021-09-01T07:03:49

This should work

SELECT 
    DESCRIPTION,
    TOTAL_ADMISSION,
    EMERGENCY,
    NORMAL      
  FROM TABLE (ORDERENTRY.PKG_S04REP00031.ADMISSION_SUMMARY(P_START_DATE => to_date('31/08/2021', 'dd/mm/yyyy') , 
                                                           P_END_DATE   => to_date('01/09/2021', 'dd/mm/yyyy') , 
                                                           P_ADMISSION_TYPE => 'NORMAL' , 
                                                           --P_ORDER_LOCATION_ID => :P_ORDER_LOCATION_ID, 
                                                           P_LOCATION_ID => 'K01')
                                                           );

You are using select from table(package.function, therefore

Parameters values in functions or packages follow the sign => not =
Parameters are separated by comma
I replaced /* */ just for --, just for cosmetic purposes, as both represent comments, but the later is more common when you want to comment just one line

ORA 00907 Missing Right Parenthesis

1 Answers