Re: service name / invalid directory path

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