Path: news.easynews.com!easynews!sn-xit-02!supernews.com!postnews1.google.com!not-for-mail
From: funfack@windhager.de (hubertus)
Newsgroups: comp.databases.oracle.server
Subject: UTL_FILE_DIR failed on network drive ...
Date: 26 Apr 2002 06:36:46 -0700
Organization: http://groups.google.com/
Lines: 32
Message-ID: <a03492ba.0204260536.339b53c@posting.google.com>
NNTP-Posting-Host: 62.157.6.101
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1019828207 6413 127.0.0.1 (26 Apr 2002 13:36:47 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 26 Apr 2002 13:36:47 GMT
Xref: easynews comp.databases.oracle.server:144726
X-Received-Date: Fri, 26 Apr 2002 06:35:13 MST (news.easynews.com)

Hi,

writing on network-drives failed with utl_file_dir

SERVER: W2K ORACLE: 8.1.6
ORA.INI: UTL_FILE_DIR = *
NETWORK-DRIVES: WINDOWS,SAMBA

writing to local drives via ORACLE does fine.
writing to network drives via notepad does fine.
writing to network drives via ORACLE (SQL-PLUS) failed.

EXAMPLE:
declare f utl_file.file_type; 
begin 
f := utl_file.fopen('i:\','test.txt', 'W'); 
utl_file.fclose(f); 
end;

FAILURE:
declare f utl_file.file_type;
*
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.UTL_FILE", line 101
ORA-06512: at "SYS.UTL_FILE", line 157
ORA-06512: at line 3

Does someone knows about this error ?

Tanks
  Hubertus