Re: Utl_file.
From: SoulSurvivor <markyg_7_at_yahoo.co.uk>
Date: 25 Mar 2003 00:58:15 -0800
Message-ID: <8d9c6fd.0303250058.1c822ece_at_posting.google.com>
Date: 25 Mar 2003 00:58:15 -0800
Message-ID: <8d9c6fd.0303250058.1c822ece_at_posting.google.com>
On line 9, could you also try using BOOKS_DIR as opposed to Books_Dir (note the case). Oracle will store the name in uppercase internally.
Also, if you are using the directory (the Oracle one that is) from any other user apaort from the one who created the directory do a
GRANT READ ON DIRECTORY BOOKS_DIR TO <other user>
M
Alexxx12 <member14441_at_dbforums.com> wrote in message news:<2679306.1048555432_at_dbforums.com>...
> Thanks for the reply.
>
> I am both the client and the server since Oracle is installed on a
> stand alone. I also created a books directory on C drive. Still it
> does not work.
Received on Tue Mar 25 2003 - 09:58:15 CET