Re: PL/SQL file I/O HELP

> 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!!

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