关于调用结果集的问题,在线等待!
创建的存储过程为:
create or replace procedure taskselect(ts_id varchar2)
as
tn varchar(20);
tam number(10,0);
begin
select task_name,amount into tn,tam from tasks where task_id=ts_id;
end;
/
在SQL*PLUS里面调用成功:
SQL> execute taskselecttry('19980001');
PL/SQL 过程已成功完成。
但在java里面为什么总是出错?帮帮忙,好急呀!
下面是我在java里的调用语句:
String procedure = "{?=call taskselect(?)}";
CallableStatement cstmt = conn.prepareCall(procedure);//执行查询
cstmt.setString(1,searchTaskID);
ResultSet rs=cstmt.executeQuery();
while(rs.next()) {
String name=rs.getString(1);
out.println(name);
}