-
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.
____________________
Pete
-
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
____________________
Pete
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|