Skip to Main Content

Oracle Database Free

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00600 when using the multi row VALUES constructor inserting into a view

Lukas EderNov 14 2023

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

This post has been answered by gsalem-Oracle on Nov 14 2023
Jump to Answer
Comments
Post Details
Added on Nov 14 2023
2 comments
254 views