Re: help on UTL

From: <G.Plivna_at_itsystems.lv>
Date: Mon, 31 Jul 2000 15:12:46 +0300
Message-Id: <10575.113356@fatcity.com>

Hi!

Have You written a line in init.ora something like utl_file_dir = <your directory>
If I remeber correctly on NT <your directory> is without slash in the end e.g. c:\mydir
I'm not sure one can use utl_file on shared directories

Gints

                                                                                                                           
                    Makarand Natu                                                                                          
                    <Makarand.Natu_at_origin        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>       
                    india.com>                   cc:                                                                       
                    Sent by:                     Subject:     help on UTL_FILE..                                           
                    root_at_fatcity.com                                                                                       
                                                                                                                           
                                                                                                                           
                    00.07.31 15:25                                                                                         
                    Please respond to                                                                                      
                    ORACLE-L

Hi Gurus,

I'm running Oracle 8.0.5 on NT-4 (SP3) on Server 1. Server 1 has a mapping E:\ pointing to Server 2\share directory. I'm trying to read a file on E:\ by using UTL_FILE package. But is is raising an INVALID_OPERATION
exception.
I have checked the file access and that is fine. Also the paths specified in UTL_FILE.FOPEN call are correct.
Help requested.. Received on Mon Jul 31 2000 - 07:12:46 CDT

Re: help on UTL_FILE..