This content has been marked as final. Show 2 replies
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.
the error seems coming from SQL statement in string form so that the compile succeed. When I use EXECUTE IMMEDIATE [SQL string], exception caught.