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.