Hi,
one of the developer at my client did a mistake and accidentally hit an old ORA-600 bug (with new version I assume). database version is 19.8 (you can reproduce this error on livesql too)
error message is ORA-00600: internal error code, arguments: [qcsrwae1], [16], [2], [11], [], [], [], [], [], [], [], []
code:
create table my_dummy(d number, y number);
create or replace procedure test(p number) as
xx number;
v_select date ;
v_into date;
begin
select d, v_select into xx, v_into
from my_dummy
where d = p
order by d
fetch first 1 rows only;
end;
/
compiling this code cause an ora 600. interestingly this error is registered at ora 600 tool on MOS. Doc ID 2064478.8
problem is this document is for Oracle 9 :) selecting a local variable in a plsql block is causing this but in this case FETCH FIRST is also causing this. if your remove FETCH it work. as a workaround select statement can be written like this and it works too:
select * into xx, v_into
from ( select d, v_select
from my_dummy
where d = p
order by d)
where rownum = 1;
of course I should start an SR. I just want to inform you guys and curious if any one of you has hit this bug.
ps: sorry for the format, I couldn't find how to format the code...