ORA ERR 600 on creatin a function.

From: Imel Rautenbach <imel_at_vst.co.za>
Date: Mon, 15 Mar 1999 09:07:35 +0200
Message-ID: <7cibi4$9mf$1@news3.saix.net>

hi all.

I get the following error :
ORA-00600: internal error code, arguments: [17112], [3510605032], [], [], [], [], [], []

When trying to create a function.

CREATE OR REPLACE FUNCTION
tstr(p_seconds IN NUMBER)
RETURN VARCHAR
is time_str varchar(8);
BEGIN

	time_str   :=
	(LPAD(FLOOR(round(p_seconds,0) / 3600), 2, 0) || ':' ||
	       LPAD(MOD(FLOOR(round(p_seconds,0) / 60), 60), 2, 0) || ':' ||
	       LPAD(MOD(round(p_seconds,0), 60), 2, 0)) ;
	return time_str;

END;
/

The second time i try this it works.
( I have to do a shutdown abort inbetween to get going again.)

I get the same error on importing.

This happens randomly on different machines and databases. HP-UX 10.20
Oracle 7.3.3.4

Thanks
Imel Received on Mon Mar 15 1999 - 01:07:35 CST