Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: UTL_FILE Oracle object
select your directory from v$parameter so is the directory changes in
the init file you don't have to rewrite your statement
"A. el Azzouzi" wrote:
> Hello there,
>
> I want to use the UTL_FILE oracle object to open a file, write, and
> then close it.
>
> But upon opening of the file, I get some errors.
> Can somebody tell me what is wrong with the next
> statement:
>
> v_FileHandle UTL_FILE.FILE_TYPE;
> ....
> v_FileHandle := UTL_FILE.FOPEN('c:\sql\', 'output.txt', 'w');
> ...
>
> Is the syntax for opening the file ok?
>
> Any reaction is welcome,
>
> A. el Azzouzi
Received on Tue Jun 29 1999 - 13:32:30 CDT