ORA-00600: internal error code, arguments...

Hi Guys

Appreciate your help on why some times I'm getting this error.
I'm using Oracle 8.0.6

Regards
Bhaskara

SQL> declare
2 v_sysdate varchar2(20);
3 begin
4 v_sysdate := to_char(sysdate);
5 dbms_output.put_line (v_sysdate);
6 end;
7 /
declare
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []
ORA-06512: at line 4


SQL> declare
2 v_sysdate varchar2(200);
3 begin
4 v_sysdate := to_char(sysdate);
5 dbms_output.put_line (v_sysdate);
6 end;
7 /
13-FEB-04

PL/SQL procedure successfully completed.

I've seen this mentioned as a problem when CURSOR_SHARING is set to FORCE. It's a bug that's supposed to be fixed in 9.0.1 according to metalink.

Try this:

declare
v_sysdate varchar2(20) ;
begin
v_sysdate := trim(to_char(sysdate,'dd-mon-yyyy hh24:mi:ss')) ;
dbms_output.put_line(v_sysdate);
end;
/

Hi Rigatoni, Tamilselvan

Thanks for your suggestions. I have tried to check for the CURSOR_SHARING parameter but I could not find it. Any idea how to set the parameter.

SQL> select name, value from v$parameter where name like 'cur%';

NAME
VALUE
cursor_space_for_time
FALSE


As suggested by Tamil, I have tried but still gotting the error.

Connected.
SQL> ed
Wrote file afiedt.buf

1 declare
2 v_sysdate varchar2(20) ;
3 begin
4 v_sysdate := ltrim(rtrim(to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'))) ;
5 dbms_output.put_line(v_sysdate);
6* end;
SQL> /
declare
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []
ORA-06512: at line 4


SQL>

Try this at the session level. I'm not sure which versions will support changing the value at the session level. It can also be set in the initOra file.

alter session set cursor_sharing=exact;


scott@AMSAA> select name, value from v$parameter where name='cursor_sharing';

NAME
----------------------------------------------------------------
VALUE
----------------------------------------------------------------------------------------------------
cursor_sharing
EXACT