jsp中调用存储过程:

create or replace procedure proce_test(
a in varchar2,
b in varchar2,
c out varchar2
)as
begin
c:=a||b;
end proce_test;
/
*/
//存储过程有两个输入一个输出参数
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
Connection conn= DriverManager.getConnection(databaseurl,databaseuser,databasepassword);
CallableStatement cmt= conn.prepareCall("{ call pr_00_jiesuan(?,?,?) }");
cmt.setString(1,"Hello ");//输入
cmt.setString(2,"world!");//输入
cmt.registerOutParameter(3, Types.VARCHAR );//注册输出参数
ResultSet rs= cmt.executeQuery();
String str= cmt.getString(3);//获取输出值
rs.close();
cmt.close();
conn.close();
%>