Re: ORA-00600 error?

From: Andy <as.no.spam.stedat_at_gmx.net>
Date: Tue, 27 Nov 2001 14:22:53 GMT
Message-ID: <3c03a0eb.966659863@by-news.bayer-ag.com>

On Tue, 27 Nov 2001 12:52:14 +0100, "Netscaper" <yummy_at_hotmail.com> wrote:

>Hello group,
>
>I got the following message with ORA 8.0.6 on Unix Server.
>
>ORA-00600: internal error code, arguments: [kkdcacr1], [], [], [], [], [],
>[], []
>
>Current SQL statement for this session:
>
>INSERT INTO BASEA.TABLEA
>
>IDKEY,KEYNAM,KEYLIB,KEYTYP,KEYSUBTYP,KEYCLASS,KEYPROP,DEVKEYACC,IDUSRDEVPRO,
>KEYDEVDAT,KEYDEVVLDDAT,KEYDEVDOCDAT ) VALUES
> :b1,'ABC','','SRV',-1,0,0,'L','???',SYSDATE,:b2,:b2 )
>
>
>Does it ring a bell to someone? Any help is greatly appreciated.
>
>Thanks,
>
>
>
>
>

First try to avoid inserting empty strings. Use NULL instead (e.g. values ('ABC',NULL,'SRV')

Then check if your bind variables are valid.

If this doesn´t help, you have to open a call at oracle support and send them the alert.log and trace files. If you have a metalink account you can use the ora-600 lookup tool to get near the problem.

hth
Andy Received on Tue Nov 27 2001 - 08:22:53 CST