pb调用存储过程错误
我的sql server 存储过程为
PROCEDURE SP_1 ( @in_out int OUT) AS
set @in_out = 168
if ( @@error <> 0 )
set @in_out = -10
select @in_out as '结果
return @in_out
在查询分析器中运行
exec SP_1 12
结果为
结果 |
168 |
SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
SQLCA.DBParm = "ConnectString='DSN=test;UID=sa;PWD=password'"
connect;
然后调用存储过程
declare ue_proc procedure for SP_1 @in_out =:li_result ;
SQLca.AutoCommit = TRUE
EXECUTE ue_proc ;
FETCH ue_proc into :li_result; //有输出参数时候用
SQLca.AutoCommit = false
messagebox('提示',li_result)
运行结果为 0
但是应该为 168
我都搞了半天了,但是结果还是错误,我都快疯掉了,请大侠帮忙