create or alter procedure test1 (
    .....)
returns (
    .....
    )
as
........
declare C cursor for (with F as (
    select x
    from table1
    where ...)
    select x...
    from F
    join .....);
begin
  open C;

  while (1 = 1) do
  begin
    fetch C
    into ......;
      if (row_count = 0) then
        leave;
      ......
      if (......) then
        suspend;
  end

  close C;
end