Re: service name / invalid directory path

Sybrand Bakker wrote:
> On 6 Jun 2006 04:03:20 -0700, "fitzjarrell_at_cox.net"
> <fitzjarrell_at_cox.net> 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';
>
> David, create directory wasn't available in 8i. It's a 9i statement.
>
> --
> Sybrand Bakker, Senior Oracle DBA

And he's not using 8i, as the error he reports does not exist (at least in the online documentation); it is found in the 9i docs and reads:

ORA-29280 invalid directory path

Cause: A corresponding directory object does not exist.

Action: Correct the directory object parameter, or create a corresponding directory object with the CREATE DIRECTORY command.

According to the error description my response is correct. Unless 8i reports the error (which, again, remains undocumented at http://tahiti.oracle.com in the 8.1.7 reference).

The question now arises: is the OP using some release of 8i or is he using 9i?

David Fitzjarrell Received on Tue Jun 06 2006 - 11:04:47 CDT