Re: utl_file.* EXCEPTIONS ignored(?); "When Others" ALWAYS seems to be used instead

In trying to solve this problem
it seems that the WHEN OTHERS exception is always taken and ALL the utl_file exceptions are ignored.

Does anyone know why?

Oracle 7.3.5 Forms 6.0.5

Mike Rainville

Mike Rainville wrote:

> Problem Description
>
> Using UTL_FILE to create or add records to a log on the hos servert,
> existing records are overwritten. Output for the last session is correct.
> Opening, creating, and closing a new file is working fine.
>
> Messages appear as expected, as though the host file was simply
> not detected. Open for read, even reading a record too, and open for append,
> even writing a record to trigger an exception for a non-existent file
> have failed.
>
> References
>
> This is necessary, because we are not upgrading to 8.0 soon, and the work
> around is hidden in BUG report 371510. See also Note: 10422419.6
> named: PROBLEMS USING UTL_FILE.
>
> I have also been studying Chapter 6 "Oracle Built-in Packages" by Fuerstein
> but something in the system is not right.
>
> Question
>
> Has anyone successfully detected a missing host file and switched
> the file's open mode from 'a' to 'w', by closing and reopening.
>
> If so, how did you test for the existence of the host file?
>
> Thanks in advance,
> Mike Rainville
>
> FYI Developer, Forms 6.0.5 client (Win 98 2nd ed. to Oracle 7.3.4.5.0 on
> Solaris 2.6 host)
Received on Thu Feb 22 2001 - 00:26:56 CET