34,587
社区成员
发帖
与我相关
我的任务
分享java调用sqlserver存储过程返回游标出错
存储过程:
CREATE PROCEDURE getCustomer
@p_rc Cursor varying OUTPUT
AS
SET @p_rc = CURSOR FOR
select * from khda
GO
java部分代码：
String sql = "{call getCustomer(?)}";
stmt = cnt.prepareCall(sql);
stmt.registerOutParameter(1, Types.OTHER);
出现错误：
[Microsoft][SQLServer 2000 Driver for JDBC]The specified SQL type is not supported by this driver.
CREATE PROCEDURE getCustomer
@p_rc Cursor varying OUTPUT
AS
SET @p_rc = CURSOR FOR
select * from khda
GO
java部分代码：
String sql = "{call getCustomer(?)}";
stmt = cnt.prepareCall(sql);
stmt.registerOutParameter(1, Types.OTHER);
出现错误：
[Microsoft][SQLServer 2000 Driver for JDBC]The specified SQL type is not supported by this driver.
...全文
请发表友善的回复…
发表回复
davytao1018 2005-03-17
- 打赏
- 举报
你游标怎么写的啊
declare cursor_name cursor for
select ..
declare
...
open cursor_name
fetch cursor_name into .. --查出几个列就要赋给几个变量
while @@fetch_status=0
begin
fetch cursor_name into ..
end
close cursor_name
dellocate cursor_name
declare cursor_name cursor for
select ..
declare
...
open cursor_name
fetch cursor_name into .. --查出几个列就要赋给几个变量
while @@fetch_status=0
begin
fetch cursor_name into ..
end
close cursor_name
dellocate cursor_name
