got it Re: PL/SQL FOpen ... Directory priviledges

From: Scott Metzger <scottmetzger_at_my-deja.com>
Date: Thu, 28 Dec 2000 22:59:41 GMT
Message-ID: <92ggkq$47g$1@nnrp1.deja.com>

The Init.ora file was called initORCL.ora

In article <92gefg$2js$1_at_nnrp1.deja.com>, Scott Metzger <scottmetzger_at_my-deja.com> wrote:
> Hi,
>
> I want to use UTL_FILE.FOPEN in PL/SQL procedure. I keep getting an
> exception when I try to open the file.
>
> FDebug := UTL_FILE.FOPEN('D:\SQL', 'debug.txt', 'w');
> UTL_FILE.PUT_LINE(FDebug, 'Hello World');
> UTL_FILE.FCLOSE(FDebug);
>
> I believe the problem is that the directory is inaccessible.
>
> I read in another post that the UTL_FILE_DIR must be set in the init.ora
> file. However, I do not have an init.ora file. I am willing to add one
> but do not know how.
>
> Any help would be aprreciated.

Sent via Deja.com
http://www.deja.com/ Received on Thu Dec 28 2000 - 16:59:41 CST