2 Replies Latest reply: Apr 22, 2010 11:00 AM by 756965 RSS

    How UTL_FILE works on split configuration


      Does UTL_FILE package can write on application tier if the location is added in dba_directories, or this needs to be on database tier in a split architecture.

      Edited by: tkjain on Nov 25, 2009 9:53 PM
        • 1. Re: How UTL_FILE works on split configuration
          Hussein Sawwan-Oracle

          I believe UTL_FILE write to the directory of the $APPLPTMP environment variable (which should be presented first in the utl_file_dir database parameter) -- See (Note: 469377.1 - How To Change Temporary Directories in Apps?).

          • 2. Re: How UTL_FILE works on split configuration
            Hi tkjain

            unfortunately, the utl_file can only write to the dbTier
            if you want to access to that file from the appsTier you must share the directory between the two tiers via NFS or samba
            this is a bad solution and you should reserve the usage of utl_file in your code only to store an internal files (such as temporary file, log, trace file...)
            You must use other solutions (FND_FILE, BI publisher...) to write or read non-internal files (interface, output, csv...)