I do not believe you are using the output parameter correctly. Could you provide an example of the sql server stored procedure you are calling.
Yes, here it is.....
create procedure getXXX
@e_id varchar(250),
@name varchar(250)
as
DECLARE @p2_output varchar(250)
declare @initvalue numeric
declare @tab1 table (childlist varchar(250))
set @p2_output = ','
declare getParentsCursor cursor local
for select e_id from tableXXX where e_name = @e_name and name = @name
open getParentsCursor
fetch next from getParentsCursor into @initvalue
while @@fetch_status = 0
begin
EXECUTE getChildren @initvalue, @p2_output OUTPUT
insert into @tab1 values(@p2_output)
fetch next from getParentsCursor into @initvalue
end
close getParentsCursor
deallocate getParentsCursor
SELECT * from @tab1
GO