Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: UTL_FILE.FOpen ends with Ora-00600 internal error when file path is null (Win2K 8.1.7.0.0)

Re: UTL_FILE.FOpen ends with Ora-00600 internal error when file path is null (Win2K 8.1.7.0.0)

From: FC <flavio_at_tin.it>
Date: 26 Oct 2002 09:30:54 -0700
Message-ID: <2bd78ddf.0210260830.3517ce64@posting.google.com>


Daniel Morgan <dmorgan_at_exesolutions.com> wrote in message news:<3DB6BF8B.136687D6_at_exesolutions.com>...
> FC wrote:
>
> > Dear all,
> > I just happen to find out that passing (involuntarily) a null value in
> > the file path parameter of the Fopen function of built-package
> > UTL_FILE causes an ORA-00600 internal error. Of course it doesn't make
> > sense to pass a null to that parameter, but there it is.
> > The bad side is that whenever such event occurs, Oracle executable
> > goes to 100% CPU usage while dumping information to the udump
> > directory, which may take several minutes to complete and choke any
> > other existing session.
> >
> > This happened on a Windows 2000 platform with 8.1.7.0.0 installed.
> >
> > Regards,
> > Flavio
>
> You must contact Oracle for support on an ORA-00600.
>
> If you don't have a support contract. Download the latest 8.1.7 and
> upgrade.
>
> Daniel Morgan

Well, I just subscribed to the techtrack but that alone doesn't entitle me to any access to metalink or support. Since the workaround is so easy, I'll not go trough an upgrade.

Bye,
Flavio Received on Sat Oct 26 2002 - 11:30:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US