Re: utl_file.fopen and Oracle v9
From: Goupil <member43406_at_dbforums.com>
Date: Thu, 09 Oct 2003 13:01:12 -0400
Message-ID: <3407785.1065718872_at_dbforums.com>
Date: Thu, 09 Oct 2003 13:01:12 -0400
Message-ID: <3407785.1065718872_at_dbforums.com>
Does the name resolution for DIRECTORY works with Oracle 9i 9.0.1
In my case the utl_file_dir in the init.ora works but i tried to use the DIRECTORY features:
CREATE DIRECTORY DIR AS 'e:\directory';
GRANT READ ON DIRECTORY DIR TO PUBLIC; then in pl/sql:
v_FileHandle := UTL_FILE.fopen('DIR', 'test.txt', 'r');
raises an invalid path exception....
-- Posted via http://dbforums.comReceived on Thu Oct 09 2003 - 19:01:12 CEST