I have an exception like this:
ORA-00907: missing right parenthesis
ORA-06512: at "KATS.ASD_FID_TIMEVIEWS_MULTILEG", line 188
ORA-06512: at line 1
where "KATS.ASD_FID_TIMEVIEWS_MULTILEG" is a procedure. The procedure is compiled and should not have any parenthesis missing. Would like to ask what possible to cause "ORA-00907: missing right parenthesis" exception? Thanks.
Did the procedure compile successfully without any warnings? ORA-00907 is due to syntax error only.
First try to execute the procedure independently. If it succeeds, then call it from the jsp.