I'm using the latest version of the 23c free database from here: https://hub.docker.com/r/gvenzl/oracle-free
Run this script:
create table t (
i number(10),
j number(10)
);
create view v
as
select t.i, t.j
from t;
insert into v (i)
values (0), (1), (2);
The INSERT
statement at the end fails with this error:
SQL Error [600] [60000]: ORA-00600: internal error code, arguments: [16608], [2], [4], [0x090DD8000], [], [], [], [], [], [], [], []
Error position: line: 15 pos: 22
Even worse, when using an inline view like this:
insert into (select i from t)
values (0), (1), (2);
Then the server just stops responding:
SQL Error [17410] [08000]: No more data to read from socket