PL/SQL FOpen ... Directory priviledges

From: Scott Metzger <scottmetzger_at_my-deja.com>
Date: Thu, 28 Dec 2000 22:22:47 GMT
Message-ID: <92gefg$2js$1@nnrp1.deja.com>

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.

Thank You,
Scott

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