Java开发网 - Java调用存储过程的问题,内详.

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

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

Posted by: hgq23
Posted on: 2004-05-21 11:56

在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