From: "Arjan van Bentem" <avbentem@DONT-YOU-DAREdds.nl>
Subject: Re: UTL_FILE.FOPEN problem..
Date: 1998/09/09
Message-ID: <6t6c7m$gb2$1@newton.a2000.nl>#1/1
References: <01bddc12$e33deb90$500112ac@DESGIN01>
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0
Organization: -
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools


>When I use UTL_FILE.fopen.. I got an exception error
>invalide_opration..

Most likely, you did not specify utl_file_dir in init.ora. For each
directory add a line like below. Each sub directory should be given
explicitly:

    utl_file_dir = /temp
    utl_file_dir = /temp/spool

Or, to allow access to all directories, just add one line:

    utl_file_dir = *

Also note that the directories should reside on the server! You can not
write to the client. If you have this and still get the error, check the
file permissions. User oracle needs access to the specified directories, not
the end-user.

>Do I have to put a '\' at the en of the directory name (first parameter)..?

No.

>     v_fichier := UTL_FILE.FOPEN(v_nom_repertoire , v_nom_fichier, 'w');

I hope you gave v_nom_repertoire and v_nom_fichier some value?

Arjan.