2 Replies Latest reply: Aug 13, 2008 8:54 PM by 644653 RSS

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

    644653
      Hi,
      I have an exception like this:
      /////
      SQLException:
      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.