Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with utl_file

Re: Problem with utl_file

From: Jpmakar <jpmakar_at_aol.com>
Date: 1998/09/09
Message-ID: <1998090902430900.WAA06090@ladder01.news.aol.com>#1/1

You can't just open any file via the UTL_FILE package. The directory path has to be defined in the init.ora file. You can find whether you currently have it set by looking in sys.v$parameters (UTL_FILE_DIR). You have to declare the path in your PL/SQL EXACTLY the way it is in the parm (i.e. It is case sensitive). Also make sure the read/write permissions in the o/s allow the ID to access the directory tree. Received on Wed Sep 09 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US