Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!nx01.iad01.newshosting.com!newshosting.com!66.150.105.54.MISMATCH!newsfeed-east.nntpserver.com!nntpserver.com!statler.nntpserver.com!news.glorb.com!postnews.google.com!u72g2000cwu.googlegroups.com!not-for-mail
From: "Rauf Sarwar" <rs_arwar@hotmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: service name / invalid directory path
Date: 6 Jun 2006 08:25:08 -0700
Organization: http://groups.google.com
Lines: 36
Message-ID: <1149607508.219201.197640@u72g2000cwu.googlegroups.com>
References: <1149588804.908212.252090@c74g2000cwc.googlegroups.com>
   <1149591800.480083.63450@y43g2000cwc.googlegroups.com>
   <1149603677.122531.179230@u72g2000cwu.googlegroups.com>
NNTP-Posting-Host: 194.131.247.202
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1149607513 12799 127.0.0.1 (6 Jun 2006 15:25:13 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 6 Jun 2006 15:25:13 +0000 (UTC)
In-Reply-To: <1149603677.122531.179230@u72g2000cwu.googlegroups.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: u72g2000cwu.googlegroups.com; posting-host=194.131.247.202;
   posting-account=3xsT9QwAAAC3x7TJbwl3Hj0DXQs_bISq
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:268626


diego.carpintero@eu.dendrite.com wrote:
> > It appears you missed a crucial step:
> >
> > create or replace directory <dirname> as '<pathname>';
> >
> > where <dirname> is the directory name you intend to use and <pathname>
> > is the <directory_name> you set  UTL_FILE_DIR to.  If, for example, you
> > set UTL_FILE_DIR = '/mydir/for/general/stuff' and your stored procedure
> > uses the string 'mydir' in the utl_file calls then the create directory
> > command should appear thus:
> >
> > create or replace directory mydir as '/mydir/for/general/stuff';
> >
> > This should allow your procedure to work, presuming your calls to
> > utl_file are using mydir as the directory component.
> >
> > > The error I am getting on the >>client<< is:
> > > "ORA-29280: invalid directory path"
> > >
>
> I only set the UTL_FILE_DIR parameter, I thought it was not necessary
> to
> create a DIRECTORY object. Well, I am going to check with
> DIRECTORY objects and I let you know if it works.
>
> Thanks

1) Is the directory local to the machine or mapped/unc?
2) If the directory is local then you don't need to change permissions
on the service. Let it run as "LocalSystem".
3) Does the directory have proper read/write permissions?

Regards
/Rauf