Calling stored procedures from JSP

[sunil kumre]

Is it possible to call stored procedures from a Jsp file?How?
thanks in advance.
sunil

[prabhatis]

try this ..
Connection con = getConnection();
CallableStatement cs = con.prepareCall("{? = call X2K.pkgQuotes.CHECKEXPIRATION(?, ?, ?)}");
cs.registerOutParameter(1, java.sql.Types.OTHER);
cs.setString(2, rootSymbol );
cs.setString(3, futureOption);
cs.setString(4, exchangeCode);
cs.execute();
rs = (ResultSet)cs.getObject(1);
while ( rs.next() )
{}
hope u can figure it out
if not ...just ask i'll be hapy to clarify
Prabhat

[Frank Carver]

"prabhatis",
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp . We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please log in with a new name which meets the requirements.
Thanks.

[prabhatis]

thanx for reminding..
i am going to reregister my serf as prabhat kumar will this do ??