How to organize transactions with returning?

Question

Oracle

There are several tables with related data.
The data is linked by id.
After adding data to the first table, the row id is formed and the data is returned via returning to add it to other tables.
Table | ID | val |
example: Returning example:

INSERT INTO table (val) VALUES ( 'data' ) RETURNING ID

All this business I wanted to make in transaction.
How there to receive value from returning?

Answer 1

I didn’t quite understand what the question was, but in order to do it within one transaction, you need to wrap everything in begin end

begin 
insert into ..... returning id into :id; 
-- ...
commit;
end;