Re: UTL_FILE exceptions

From: hazledid <david.hazledine_at_roche.com>
Date: Tue, 04 May 1999 11:17:38 GMT
Message-ID: <mHAX2.3426$vY2.17404@c01read01.service.talkway.com>

On 30 Apr 1999 16:09:03 GMT mwilhelm_at_ccat.sas.upenn.edu (Mark C. Wilhelm) wrote:
> Is there a way to return a more specific OS error via a UTL_FILE exception?

I'm not aware of any method. Things you might want to check for a WRITE_ERROR include:

Is the output directory named in the database's INITsid.ORA file?
Does the Oracle server process have write access to the directory?
Is the disk full?

Hope this helps.

David J. Hazledine
Roche Products Limited
40 Broadwater Road
Welwyn Garden City
AL7 3AY
United Kingdom
Registration Number 100674
Tel. +44 (0)1707 366166
--
Posted via Talkway - http://www.talkway.com Exchange ideas on practically anything (tm). Received on Tue May 04 1999 - 06:17:38 CDT