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

Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL file I/O HELP

Re: PL/SQL file I/O HELP

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

Brent Laminack (brent_at_cc.gatech.edu) wrote:
: > 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/"
: ^
: |
: BEWARE!! BEWARE!! BEWARE!!
Afraid not in the HPUX world if it is NOT there is will not work. HPUX 10.X Oracle 7.3.2.3, i use it every day :)

: The O'Reilly book on PL/SQL says to put in the trailing slash,
: Oracle support and my expreience show this may fail. At least
: on 7.3.2.2.0 you need to leave the trailing slash off.
 

: Brent Laminack (brent_at_ecweb.com)
 

-- 
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 Thu Feb 27 1997 - 00:00:00 CST

Original text of this message

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