UTL_FILE_DIR failed on network drive ...

From: hubertus <funfack_at_windhager.de>
Date: 26 Apr 2002 06:36:46 -0700
Message-ID: <a03492ba.0204260536.339b53c@posting.google.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 Received on Fri Apr 26 2002 - 08:36:46 CDT