By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
execute block
returns (firstval integer, secondval integer)
as
declare function x(param1 integer) returns integer
as
declare var1 integer;
begin
var1 = param1 * 2;
return param1 + var1;
end
begin
firstval = 1;
while (firstval < 10) do
begin
secondval = x(firstval);
suspend;
firstval = firstval + 1;
end
end
| FIRSTVAL | SECONDVAL |
|---|---|
| 1 | 3 |
| 2 | 6 |
| 3 | 9 |
| 4 | 12 |
| 5 | 15 |
| 6 | 18 |
| 7 | 21 |
| 8 | 24 |
| 9 | 27 |