UTL_FILE

From: Zephyr <p.neumann_at_ids-scheer.de>
Date: Tue, 15 Feb 2005 14:35:40 +0100
Message-ID: <4211fb02$0$5303$4d4ebb8e@read-nat.news.de.uu.net>

Hi,

I want to write from a procedure into a file on the server using UTL_FILE and do not have a parameter
UTL_FILE_DIR= in my init.ora specifiing a path. The server version is 9.2.0.4 and as far as I know,
I do not need UTL_FILE_DIR with this version. I'am using 'create directory...' instead.

This is my code for writing in a file on a windows machine

p_FileDir varchar2 (50) := 'C:\';
--p_FileDir varchar2 (50) := '\\elseserver\results'; p_FileName varchar2 (20) := 'user.txt';

v_FileHandle := UTL_FILE.FOPEN (p_FileDir, p_FileName, 'w'); UTL_FILE.PUT_LINE (v_FileHandle, v_text);

I tried several volumes, folders, notations and UNC notation, but always get

ORA-29280: invalid directory path

Has anyone a hint, or do I need the UTL_FILE_DIR parameter set on the oracle server?

Thanx
Patrick Received on Tue Feb 15 2005 - 07:35:40 CST