Re: UTL_FILE Oracle object
From: Mark G <mgumbs_at_nospam.hotmail.com>
Date: Wed, 23 Jun 1999 15:18:06 +0100
Message-ID: <3770ea54.0_at_145.227.194.253>
Date: Wed, 23 Jun 1999 15:18:06 +0100
Message-ID: <3770ea54.0_at_145.227.194.253>
- Make sure that in your init.ora file, you have specified the directories which you will be able to write to. e.g utl_file_dir = 'c:\temp'
- In your line, you don't need the trailing slash
v_FileHandle := UTL_FILE.FOPEN('c:\sql', 'output.txt', 'w');
HTH, Mark
- el Azzouzi wrote in message <7kqopd$16s0$1_at_news.accu.uu.nl>...
>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
>
>
>
>