Re: service name / invalid directory path

diego.carpintero_at_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 Received on Tue Jun 06 2006 - 10:25:08 CDT