Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!y43g2000cwc.googlegroups.com!not-for-mail
From: "fitzjarrell@cox.net" <fitzjarrell@cox.net>
Newsgroups: comp.databases.oracle.server
Subject: Re: service name / invalid directory path
Date: 6 Jun 2006 04:03:20 -0700
Organization: http://groups.google.com
Lines: 56
Message-ID: <1149591800.480083.63450@y43g2000cwc.googlegroups.com>
References: <1149588804.908212.252090@c74g2000cwc.googlegroups.com>
NNTP-Posting-Host: 192.85.47.1
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1149591806 1912 127.0.0.1 (6 Jun 2006 11:03:26 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 6 Jun 2006 11:03:26 +0000 (UTC)
In-Reply-To: <1149588804.908212.252090@c74g2000cwc.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: y43g2000cwc.googlegroups.com; posting-host=192.85.47.1;
   posting-account=B_KC8Q0AAADcSTVy4DZ59utFaLrVLOo4
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:268607

Comments embedded.
diego.carpintero@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