RSS Forums RSS
Please support our JSP advertiser: Lunarpages JSP Web Hosting
Views: 4626 | Replies: 0
Reply
Join Date: Jul 2005
Posts: 1
Reputation: elimera is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
elimera elimera is offline Offline
Newbie Poster

jsp - oracle

  #1  
Jul 13th, 2005
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!!!
AddThis Social Bookmark Button
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes
Forums | Blogs | Tutorials | Code Snippets | Whitepapers | RSS Feeds | Advertising
All times are GMT -4. The time now is 12:12 pm.
Newsletter Archive - Sitemap - Privacy Statement - Acceptable Use Policy - Contact Us
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC