CREATE TABLE TEST (
 ID  INTEGER NOT NULL
);
ALTER TABLE TEST ADD CONSTRAINT PK_TEST PRIMARY KEY (ID);

execute block
returns (i integer)
as
begin
  in autonomous transaction do
    insert into test(id) values(1);
  select id from test into :i;
  suspend;
end