yes you can call stores procedures in jsp.
here is an example
CallableStatement cs = con.prepareCall("{call
PROC_get_next_track_id (?,?,?,?)}");
cs.setString(1,"Track_Id");
cs.registerOutParameter(2,
Types.INTEGER);
cs.registerOutParameter(3,
Types.INTEGER);
cs.registerOutParameter(4,
Types.VARCHAR);
// Calling the procedure in
the database
cs.executeUpdate();
// Handling the output
x = cs.getInt(2);
__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
