I'm fighting with this since two days....


SP1 source code :

begin
execute procedure SP2 (fills some records into table tmp_table)

for
select number
from tmp_table
into ret_value
do
begin
suspend
end
end /* end of SP1 */


SP2 source code (simplified) :

begin
delete from tmp_table

for
select invoice_number
from tbl_invoice
where (some criteria)
into var_invoice_number
do
begin

/* if select statement gives <n> records, this */
/* "if decision" is for every of this <n> record?? */
if var_invoice number=(some criteria)then
begin
insert into tmp_table(var_invoice_number)
end

suspend
end
end


Is it normal, that if there is no (dummy) return value defined for
SP2, SP2 is writing nothing into tmp_table ???

If I call SP2 directly the expected values are in the tmp_table. If I
call SP1, the tmp_table is empty.....

Any ideas?

Ulrich