Multi table insert atomic?

Reading SQL and Relational Theory: How to Write Accurate SQL Code. Talking about constraints and data modifications. There should be able to update several tables in one atomic operation. Oracle multi table insert could be something to that direction, but no atomicy. Bug still open from version not any more supported.

SQL> create table a (a_id number(1) primary key
  2                , b_id number(1) not null);

Table created.

SQL> create table b (b_id number(1) primary key
  2                , a_id not null constraint b_a_fk references a );

Table created.

SQL> alter table a add
  2    constraint a_b_fk foreign key (b_id) references b
  3      deferrable initially deferred;

Table altered.

SQL> insert all into b values (x,x)
  2  into a values (x,x)
  3  select 0 x
  4    from dual;
insert all into b values (x,x)
*
ERROR at line 1:
ORA-02291: integrity constraint (RAFU.B_A_FK) violated - parent key not found


SQL> insert all into a values (x,x)
  2  into b values (x,x)
  3  select 1 x
  4    from dual;

2 rows created.

SQL> insert into a values (2,2);

1 row created.

SQL> insert into b values (2,2);

1 row created.

SQL> select * from a;

      A_ID       B_ID
---------- ----------
         1          1
         2          2

SQL> rollback;

Rollback complete.