Re: PL/SQL file I/O HELP

From: Joseph Testa <jtesta_at_freenet.columbus.oh.us>
Date: 1997/02/26
Message-ID: <5f1ege$s9b@login.freenet.columbus.oh.us>#1/1

Colin Polykett (polyketc_at_bibip1.spam.wgw.bt.co.uk) wrote:

: c581534_at_sp2n09.missouri.edu wrote:

: >
: > Hi there:
: > I came cross one problem using fopen procedure within oracle PL/SQL
: > UTL_FILE package. I kept getting exception indicating invalid path. I'm
: > accessing the ORACLE server through a UNIX machine. Does anyone can
: > give me some suggestion on this. THANKS a lot. The followig is the
: > procedure I used to open a file:
: > UTL_FILE.FOPEN('dir path', 'filename' 'r');
: >

<snip>

here is what i use(HPUX platform)

  in the plsql code  

UTL_FILE.FOPEN('/u02/home/dba/oracle/flat/EPA2/','test.txt','r');

and the init.ora file the entry is:

utl_file_dir="/u02/home/dba/oracle/flat/EPA2/"

Hope that helps

joe

-- 
Joseph S. Testa, Database Administrator, Ohio EPA
  N8XCT, Emergency Coordinator (EC) & Local Govt Liaison (LGL)
  Pickaway County, OH and Official Relay Station (ORS), message content
  are MY views and NOT my current employer.

Received on Wed Feb 26 1997 - 00:00:00 CST