create table data (
    id     integer not null,
    name   varchar(32) not null
);

alter table data
  add constraint pk_data primary key (id);

alter table data
  add constraint unq_data unique (name);

insert into data ( id, name ) values( 1, 'Name #1' );
insert into data ( id, name ) values( 2, 'Name #2' );
insert into data ( id, name ) values( 3, 'Name #3' );

commit;

set term ^ ;

create procedure sp (
    id       integer,
    name     varchar(32) )
returns (
    id_name varchar(40))
as
begin
  id_name = :id || ' - ' || :name;
  suspend;
end ^

set term ; ^

select d.id, d.name, p.id_name
  from data d
  join sp( d.id, d.name ) p on ( 1 = 1 );

  left join sp( d.id, d.name ) p on ( 1 = 1 )

set term ^ ;

create procedure join_sp
returns ( id integer,
          name varchar(32),
          id_name varchar(100) )
as
begin
  for
    select d.id, d.name, p.id_name
      from data d
      join sp( d.id, d.name ) p on ( 1 = 1 )
      into :id, :name, :id_name
  do
    suspend;
end ^

set term ; ^