I wrote a JSP page that connects to a Oracle database. I did a SELECT statement to find out procedures and I printed the procedure into a form. In this form I can modify the procedure and save it.
Then I created a sql statement to modify the procedure and I executed it.
The problem is that if there are some mistakes into the procedure there aren't message errors and the procedure is saved every time.
The code is:
Statement stmt=cn.createStatement();
String textProcedure=request.getParameter("text_in_form");
String sql="CREATE OR REPLACE " + textProcedure;
stmt.execute(sql);
Sorry for my terrible english...
Thank you!!!