create or replace procedure proc_test(p_str varchar2) is
begin
null;
end;
/
有java程序如下
import java.sql.*;
import java.util.*;
import oracle.jdbc.driver.*;
import oracle.sql.*;
public class test
{
public static void main(String args[]) throws Exception
{
String outstr ="";
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection con = DriverManager.getConnection("jdbc:oracle:oci8:@local","user", "pass");
OracleCallableStatement cstmt = (OracleCallableStatement) con.prepareCall("begin proc_test(?); end;");
long s = System.currentTimeMillis();
//我希望每次客户端(WEB页面)传入参数给这个java程序总是从这一行里开始执行，
//也就是prepareCall存储过程一次，调用存储过程多次，调用次数会很多
cstmt.setString(1,"客户端传入的参数值");
cstmt.execute();
long e = System.currentTimeMillis();
System.out.println(e - s);
}
}
