Re: service name / invalid directory path

In article <44857b2a$0$11072$9b4e6d93_at_newsread4.arcor-online.net>, Maxim Demenko says...
> Sybrand Bakker schrieb:
> > 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
>
> David is probably correct on it.
>
> sqlplus "/ as sysdba"
>
> SQL*Plus: Release 8.1.7.0.0 - Production on Tue Jun 6 14:49:34 2006
>
> (c) Copyright 2000 Oracle Corporation. All rights reserved.
>
>
> Connected to:
> Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
> With the Partitioning option
> JServer Release 8.1.7.4.0 - Production
>
> SQL> create directory tmp as '/tmp';
>
> Directory created.
>
> SQL>
>
>
>

IIRC you couldn't use UTL_FILE on a directory object in 8i - directories were there for other purposes - in 8i you still had to define the UTL_FILE_DIR in the init.ora

I could be wrong but don't think I am.

(famous last words..)

-- 
jeremy

We use Oracle 9iR2 on Solaris 8 with the Oracle HTTP Server and 
mod_plsql