DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

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

  1. #1
    Join Date
    Oct 2003
    Posts
    21

    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.

  2. #2
    Join Date
    Nov 2003
    Location
    Ohio
    Posts
    51
    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

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    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;
    /

  4. #4
    Join Date
    Oct 2003
    Posts
    21
    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>

  5. #5
    Join Date
    Nov 2003
    Location
    Ohio
    Posts
    51
    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
  •  


Click Here to Expand Forum to Full Width