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();就会报以上错误,请帮忙看看,非常感谢
我自己找到问题了,虽然还是不怎么明白。
在调用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);
%>
先看你的存储过程能不能被数据库正确执行。然后再看JSP调用
CREATE OR REPLACE procedure SAJET.test_levi(i in varchar)
as
begin
insert into temp_levi(name) values(i);
commit;
end;
改
CREATE OR REPLACE procedure SAJET.test_levi(i in varchar)
as
begin
insert into temp_levi(name) values('|| i || ');//这是字符串,需要单引号。先把存储过程调试的能运行
commit;
end;
刚注册,就几个C币,这两个C币怎么给你们啊???