set term ^ ;

create table TEST(
ID bigint,
ID_SP bigint,
primary key (ID)
)
^

create procedure TEST_SP(
ID_IN bigint
) returns (
ID_SP bigint,
ID_OUT bigint
) as
begin
 insert into TEST(ID, ID_SP) values (:ID_IN, :ID_IN);
 ID_SP = :ID_IN;
 ID_OUT = :ID_OUT;
 suspend;
end
^

select sp.ID_SP, t.ID
from TEST_SP( 1) sp
left join TEST t on t.ID_SP = sp.ID_SP
^