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>


  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
    >
    >
    >
    >
Received on Wed Jun 23 1999 - 16:18:06 CEST

Original text of this message