Re: Problem with UTL_FILE

I am not surprised. I too am running Ora 8.1.5 on NT. I cannot even use the UTL_FILE functions unless the init.ora has utl_file_dir defined in it AND I am using that value as the first parameter in utl_file.fopen (). Seems stupid and redundant.

Still, once those values are set, the UTL_FILE functions do work quite well.

Rock Cogar.
Radian International LLC.
Oak Ridge, TN. USA.

In article <825omr$4lc$1_at_nnrp1.deja.com>,   efflerch_at_my-deja.com wrote:
> Hi,
>
> if someone writes a procedure at my system which tries to open a file
> for writing in a not defined(wrong) utl_file_dir the whole database
> crashes (Oracle.exe is killed)
> for inst.
> utl_file_dir:='c:\wrong\directory'
> file_id := UTL_FILE.FOPEN(utl_file_dir, utl_file_name, 'W');
>
> My System:
> Oracle 8i at WinNT (Compaq proliant 4 Proc 1GB RAM )
> (upgraded from V7.1 => V7.33=> V8.03=> V8.04=> V8.05=> V8.1.5)
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Dec 02 1999 - 08:30:48 CST