Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: service name / invalid directory path
> 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 Received on Tue Jun 06 2006 - 09:21:17 CDT