Re: UTL_FILE Oracle object

[Quoted] 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 - 20:32:30 CEST