Re: service name / invalid directory path

Comments embedded.
diego.carpintero_at_eu.dendrite.com wrote:
> This question is for Oracle 8i.
>

8.1.5?? 8.1.6?? 8.1.7??

> It is possible to assign permissions to a Service Name??
>

No.

> Well, I am facing a "Invalid directory path" problem.
>
> The steps I did on the >>server<< are:
>
> 1) I wrote a procedure that uses the utl_file package
> 2) I set the parameter UTL_FILE_DIR = <directory name>
> 3) I restarted the database
>

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

See above; you haven't created a DIRECTORY within Oracle.

> I have the feeling it could be a problem with the Service Name I am
> using.
>

It has nothing to do with the Service Name, and everything to do with completing the given task properly.

> Any suggestions?
>
> Thanks in advance

David Fitzjarrell Received on Tue Jun 06 2006 - 06:03:20 CDT