Re: UTL_FILE problem

From: Kenneth C Stahl <BlueSax_at_Unforgettable.com>
Date: 2000/05/22
Message-ID: <392965B1.F6CF883D@Unforgettable.com>#1/1

Frank Han wrote:
>
> I wrote utl_file.sql to test UTL_FILE package. Our DBA has set
> UTL_FILE_DIR=oracle8i/tmp and I have mapped oracle/tmp to drive e: I have
> full control rights for drive e: and e:\han. The program and error message
> are as followings.

use: utl_file_dir=c:\oracle8i\tmp

If that is the only directory allowed then you cannot write to any other directory. If you want to add e:\han as an allowed directory then you need to add:

utl_file_dir=e:\han

Make sure you bounce the database after you change the parameter file. Received on Mon May 22 2000 - 00:00:00 CDT