create temp table tmp_table1(id_val INT) lock mode row;
insert into tmp_table1 values( 1 );                        
insert into tmp_table1 values( 2 );
insert into tmp_table1 values( 3 );

create procedure tmp_pair(
  i int
) returning
   int
 , int
 ;

  return i, i;
 
end procedure; 

execute procedure tmp_pair( 2 );
execute procedure tmp_pair( 3 );
 
create procedure tmp_test_dsql(
) returning
    int
  , int
  ;

  define i_val int;
  define i_i1, i_i2 int;
  define s_sql varchar( 120 );
  foreach
    select id_val into i_val
      from tmp_table1 
         order by  1  desc

    let  i_i1, i_i2 =  0 , 0 ;
    let s_sql ="execute procedure tmp_pair("||i_val||"); ";
    PREPARE tmp FROM s_sql;
    DECLARE cur cursor FOR tmp;
    OPEN cur;
    FETCH  cur INTO i_i1, i_i2;
    CLOSE cur;
    FREE tmp;
    FREE cur;
    return i_i1, i_i2 
      with resume; 
  end foreach	
end procedure;

-- вот здесь видна проблема
execute procedure tmp_test_dsql();
-- возвращается 3 записи и все с одинаковыми полями = 3...

-- чистим за собой
drop procedure tmp_test_dsql();
drop procedure tmp_pair(int);
drop table tmp_table1;

create procedure tmp_test_dsql(
) returning
    int
  , int
  ;

  define i_val int;
  define i_i1, i_i2 int;
  define s_sql varchar( 120 );
  foreach
    select id_val into i_val
      from tmp_table1
        order by  1  desc 
 
    let  i_i1, i_i2 =  0 , 0 ;
    let s_sql ="execute procedure tmp_pair("||i_val||"); ";
    if i_val =  3  then
      PREPARE tmp FROM s_sql;
      DECLARE cur cursor FOR tmp;
      OPEN cur;
      FETCH cur INTO i_i1, i_i2;
      CLOSE cur;
      FREE tmp;
      FREE cur;
    else
      PREPARE tmp2 FROM s_sql;
      DECLARE cur2 cursor FOR tmp2;
      OPEN cur2;
      FETCH  cur2 INTO i_i1, i_i2;
      CLOSE cur2;
      FREE tmp2;
      FREE cur2;
    end if
    return i_i1, i_i2 
      with resume; 
  end foreach	
end procedure;

...
    let sql ="execute procedure  "||  alias||"myspl( ? ); ";
...