pb关于调用存储过程的问题?
CREATE proc CkcrmxInsertData @djh varchar(20)
,@i int output
as
set nocount on
declare @ckbm varchar(4)
declare @cklb varchar(4)
declare @spdm varchar(20)
declare @cbdj numeric(15,2)
declare @xsdj numeric(15,2)
declare @sl numeric(15,2)
declare @djrq datetime
declare @crklx varchar(4)
select @i=0
declare curdjdetail cursor for select spdm,cbdj, xsdj, sl from djdetail where djh=@djh
open curdjdetail
select @ckbm=ckbm ,@djrq=scrq,@crklx=crklx from dj where djh = @djh;
select @cklb=cklx from ck where ckbm=@ckbm
fetch next from curdjdetail into @spdm,@cbdj,@xsdj,@sl
while @@fetch_status=0
begin
insert into ckcrmx(ckbm,cklb,spdm,cbdj,xsdj,sl,djrq,crklx)
values(@ckbm,@cklb,@spdm,@cbdj,@xsdj,@sl,@djrq,@crklx);
fetch next from curdjdetail into @spdm,@cbdj,@xsdj,@sl
select @i=@i+1
end
close curdjdetail
deallocate curdjdetail
GO
我用以下代码调用却不对请各位指点。
declare addck procedure for scjxc.ckcrmxInsertData @djh=:current_djh,@i=:updatecount out;
EXECUTE addck;
fetch addck into:updatecount;
问题点数：0、回复次数：2Top
1 楼workhand（我可憨了...）回复于 2003-12-03 13:58:04 得分 0
提示什么错误？
fetch语句中into后面加个空格阿
执行完检查sqlca.sqlcode ,sqlerrtextTop
2 楼371xingxiu（星宿）回复于 2003-12-03 14:03:02 得分 0
调试一下吧，看看错误原因再说？Top
