pb中調用sql存儲過程(帶參數和返回值)
声明储存过程:
CREATE PROCEDURE proc_pslx ( @NAME varchar(2) ,@count integer output)
AS
select @count = Count(*) from wo_info where whs_name=@NAME ;
GO
//在PB中调用:
Integer li_rtn
DECLARE lpro_test PROCEDURE FOR proc_pslx @name='C1', @count = :li_rtn OUTPUT;
EXECUTE lpro_test;
Fetch lpro_test INTO :li_rtn;
messagebox("",string(li_rtn))
//在PB中調用存儲過程時參數名稱要和SQL中的一致。