Re: UTL_FILE_DIR failed on network drive ...

First: I would NEVER NEVER use * for utl_file_dir. That means the entire machine is wide open. Anybody with access to the database can write any file on any disk on the machine with the priviliges of the Oracle user, which has local administrator priviliges on W2K.

Second: Are you really sure you want to write to a network drive? There are risks involved, like not being available.

Keep in mind that the process really writing (or reading) the file on disk is the Oracle server process that runs with the priviliges of the Oracle user so the Oracle user must have the appropriate priviliges to the drive.

hubertus <funfack_at_windhager.de> schreef in berichtnieuws a03492ba.0204260536.339b53c_at_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 - 13:57:24 CDT