Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: Jeremy <jeremy0505@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: service name / invalid directory path
Date: Tue, 6 Jun 2006 15:03:22 +0100
Lines: 61
Message-ID: <MPG.1eef9b783a10507898a1fc@news.individual.net>
References: <1149588804.908212.252090@c74g2000cwc.googlegroups.com> <1149591800.480083.63450@y43g2000cwc.googlegroups.com> <j4qa82tu4ct8665roaqlf24cofqcnqq5fb@4ax.com> <44857b2a$0$11072$9b4e6d93@newsread4.arcor-online.net>
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-15"
Content-Transfer-Encoding: 7bit
X-Trace: individual.net 4wEjC2pa8SkJeXfr6dpuBAdqOTR29aRevQAowBq/75dqlvIUsJ
User-Agent: MicroPlanet-Gravity/2.60.2060
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:268618

In article <44857b2a$0$11072$9b4e6d93@newsread4.arcor-online.net>, Maxim 
Demenko says...
> Sybrand Bakker schrieb:
> > On 6 Jun 2006 04:03:20 -0700, "fitzjarrell@cox.net"
> > <fitzjarrell@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