If I need to call a stored procedure with 6 input parameters and 6 output parameters, how would I do this? Would it look like this?... cstmt = con.prepareCall("{?, ?, ?, ?, ?, ? = CALL MKTDS22B (?, ?, ?, ?, ?, ?)}"); or this?... cstmt = con.prepareCall("(CALL MKTDS22B (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ,?))" ); Please help! Thanks!
Gerry Giese
Ranch Hand
Joined: Aug 02, 2001
Posts: 247
posted
0
Donna, Try the JDBC Documentation at java.sun.com. You'll probably get a much better response if you post in the JDBC forum instead of the Servlet forum, since this question has nothing to do with Servlets. Bartender, can you move it? Also, you should try searching the JDBC forum for similar questions that may have answers already.
CJP (Certifiable Java Programmer), AMSE (Anti-Microsoft Software Engineer)<br />Author of <a href="http://saloon.javaranch.com/cgi-bin/ubb/ultimatebb.cgi" target="_blank" rel="nofollow">Posts in the Saloon</a>
SAFROLE YUTANI
Ranch Hand
Joined: Jul 06, 2001
Posts: 257
posted
0
Calling a stored procedure from a servlet is a bad idea and usually indicates a poor design. You may want to add a layer of abstraction between your servlet and your data access calls, such as a data access object. SAF
0
