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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
146 views