2 Replies Latest reply on Aug 14, 2008 1:54 AM by 644653

    JSP to call procedure and get ORA-00907:missing right parenthesis

      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.