Re: UTL_FILE Oracle object

1. 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'
2. In your line, you don't need the trailing slash

     v_FileHandle := UTL_FILE.FOPEN('c:\sql', 'output.txt', 'w');

HTH, Mark

1. 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
   >
   >
   >
   >