急……在线等候，PB的存储过程问题

[zhaoyu2003]

存储过程:
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO



ALTER procedure procedure1
@goodname varchar(100),
@output1 varchar(100) output,
@output2 varchar(100) output
as
begin
select @output1=info_good.goodname,
@output2=info_good.goodcode
from info_good
where info_good.goodcode=@goodname
end


GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

powerscript:
String ls_name,ls_code,ls_good,ls_null
ls_null=''
declare p_procedure1 procedure for procedure1
@goodname=:ls_name,
@output1=:ls_null output,
@output2=:ls_null output;
execute p_procedure1;
messagebox('',sqlca.sqlerrtext)
fetch p_procedure1 into :ls_code,:ls_good;
close p_procedure1;
messagebox('',ls_code+ls_good)
sle_2.text=ls_code
sle_3.text=ls_good

错误信息:
Space must be allocated for bind parameter!

能不能说说这是怎么回事?

[huangxinru]

在调用存储过程前，ls_name未赋值

[zhaoyu2003]

赋了值也是一样的错误呀

[huangxinru]

你这里应该加续行符,试一下
declare p_procedure1 procedure for procedure1
@goodname=:ls_name,&
@output1=:ls_null output,&
@output2=:ls_null output;
execute p_procedure1;

[zhaoyu2003]

好像和续行没关系吧……我试了，还是不行呀……救俺呀

[huangxinru]

up

[zhaoyu2003]

高手呀……

[huangxinru]

Sorry!的确可以不加续行符

[zhaoyu2003]

TO：coordinate(什么)
按此要求则出现错误：
“对于造型出现无效的字符！”

[sinkiangscorpio]

关注

[msdn_vipuser]

up!!

[coordinate]

1.String ls_name,ls_code,ls_good,ls_null
declare p_procedure1 procedure for procedure1
@goodname=:ls_name,
@output1=:ls_null output,
@output2=:ls_null output;
写成
String ls_name,ls_code,ls_good,ls_null,ls_null2
declare p_procedure1 procedure for procedure1
@goodname=:ls_name,
@output1=:ls_null output,
@output2=:ls_null2 output;
也就是说在参数那不写两个ls_null
2.再试试
ls_name=space(100)
ls_null=space(100)
等