Java调用存储过程的问题,内详.

hgq23

在Java里用这样的代码:
CallableStatement cs = null;
cs = conn.prepareCall("{call test(?, ?, ?)}";
cs.setString(1, "aaaaa";
cs.setString(2, "babababababa";
cs.registerOutParameter(3, 1);
cs.execute();
int i = cs.getInt(3);
System.out.println("i = " + i);
存储过程test:
ALTER PROCEDURE test
@test1 as varchar(20),  
@test2 as varchar(20),  
@nRet int output
AS
insert into test_table(test1, test2) values(@test1, @test2)
set @nRet = @nRet + 100

错误:[Microsoft][SQLServer JDBC Driver]The requested data is not available.

如果把存储过程改为:
ALTER PROCEDURE test
@test1 as varchar(20),  
@test2 as varchar(20),  
@nRet int output
AS
set @nRet = @nRet + 100
程序正常运行.

数据库:MS Server2000