Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: UTL_FILE.FOPEN problem..
> 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.
>
Thanks.. This will solve my problem.. Im sure of that..!!
> >Do I have to put a '\' at the en of the directory name (first
parameter)..?
>
> No.
>
ok..!
>
> I hope you gave v_nom_repertoire and v_nom_fichier some value?
>
Yep.. !! Received on Wed Sep 09 1998 - 00:00:00 CDT
![]() |
![]() |