Jeremy schrieb:
> 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..)
>
>
Oh, i see your ( and Sybrand's) point, sorry for noise.
Best regards
Maxim
Received on Tue Jun 06 2006 - 09:17:45 CDT
