Re: ORA ERR 600 on creatin a function.

Ora 600 errors have been popping up on the newsgroup reguarly nowadays. Unfortunately, this kind of error is nornally beyond a normal fix and oracle support may have to be contacted directly. May be due to an operating system error.

Phone oracle and give them the code, operating system, oracle version etc and they may be able to tell you something.

Mark

Imel Rautenbach wrote in message <7cibi4$9mf$1_at_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 - 02:53:59 CST