Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help needed on UTL_FILE
u need to set up 'UTL_FILE_DIR' parameter in initailization parameter file . This parameter denotes the directory where utl_file will access the files from.
hope this helps
Maarten Scharroo <m.scharroo_at_elsevier.nl> wrote in article
<350F887F.D8608076_at_elsevier.nl>...
> Hi,
>
> I'm relatively new to Unix. I created a procedure using UTL_FILE to
> create a flat-file. However I have problems with the UTL_FILE.FOPEN
> statement. It needs a location, filename and an open_mode. Typing pwd
> from the command_line gives /home/mscharro/log. Using /home/mscharro/log
> as location raises the utl_file.invalid_path exception. Can anyone
> please help.
>
> Many thanks.
>
> Maarten
>
>
Received on Wed Mar 18 1998 - 00:00:00 CST
![]() |
![]() |