Re: utl_file

From: Doug S <dswanson1_at_mmm.com>
Date: Tue, 18 Aug 1998 12:45:02 -0500
Message-ID: <35D9BD9E.7AB1@mmm.com>

> INVALID_OPERATION at the FOPEN of a new file.
> Note that the path is surely valid, the name is normal (xx.dat) and the attribute is 'w' so that the
> file is created if it don't exist!!!
> Is there some system attribute that I have bypassed or not set??
> I have also set the utl_file_dir = * in ORA file

It sounds like a rights issue on the server...also I believe that utl_file_dir = * is not very secure...try setting that to a specific directory that you (the person logged on) has rights to.

hth
doug

Opinions expressed herein are my own and may not represent those of my employer. Received on Tue Aug 18 1998 - 12:45:02 CDT