Re: UTL_FILE Oracle object

From: Barth Siemens <nospam_at_uniserve.com>
Date: Mon, 28 Jun 1999 14:27:19 GMT
Message-ID: <377785be.292604032@news.uniserve.com>

On Wed, 23 Jun 1999 15:51:24 +0200, "A. el Azzouzi" <A.elAzzouzi_at_cta.usc.uu.nl> 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?

Check v$parameter to see that the value of 'utl_file_dir' is exactly the same (case and characters) as the first parameter of FOPEN. --
Barth Siemens
Change the email address from nospam to bsiemens. Received on Mon Jun 28 1999 - 09:27:19 CDT