jsp調用存儲過程報錯，請幫忙看看。謝謝

Question

CREATE OR REPLACE procedure SAJET.test_levi(i in varchar)
as
begin
insert into temp_levi(name) values(i);
commit;
end;
/

<%String driver = "oracle.jdbc.driver.OracleDriver";
String strUrl = "jdbc:oracle:thin:@10.240.144.110:1521:SAJET";
Class.forName(driver);
Connection conn = DriverManager.getConnection(strUrl,"sajet","te");
out.print(conn);
String procedure = "{call sajet.test_levi(?)}";
CallableStatement cstmt = conn.prepareCall(procedure);
cstmt.setString(1,customer);
cstmt.execute();
conn.close();
out.print(cstmt);
out.print(customer);
%>

java.sql.SQLException: ORA-06550: line 1, column 8:
PLS-00103: Encountered the symbol "?" when expecting one of the following:

begin case declare exit for goto if loop mod null pragma
raise return select update while with
<外加雙引號的分界 ID> <連結變數> << close current
delete fetch lock insert open rollback savepoint set sql
execute commit forall merge pipe
The symbol "?" was ignored.

执行到cstmt.execute();就会报以上错误，请帮忙看看，非常感谢

Answer 1

我自己找到问题了，虽然还是不怎么明白。
在调用procedure的时候需要加上begin end;
改过后的代码：
<%String driver = "oracle.jdbc.driver.OracleDriver";
String strUrl = "jdbc:oracle:thin:@10.240.144.110:1521:SAJET";
Class.forName(driver);
Connection conn = DriverManager.getConnection(strUrl,"sajet","tech");
out.print(conn);
//String procedure = "{call sajet.test_levi(?)}";
CallableStatement cstmt = conn.prepareCall("begin sajet.test_levi(?);end;");
cstmt.setString(1,"sssss");
cstmt.execute();
conn.close();
out.print(cstmt);
%>