9i external tables - reading file from the network

[zulu99]

Hi


We are using 9i external tables for reading data from the files.
The files are on the same machine on which the oracle9i database server is installed.


The files are actually uploaded & reside originally on a different machine where our app server is installed.

Currently we copy all the files into teh machine where orcle 9i databse server is installed & then use external tables to read the same.

What i would like to know is that is it possible to read files for external tables over the network

If yes can some one give an example


Rgrds

[zulu99]

forgot to add i am using win2k OS

[stmontgo]

same user/pass on same domain from the app serv?

Use the UNC name in the cr8 dir and utl_file like the below example......

CREATE DIRECTORY test_dir AS '\\myserver\look_for_files_here';

CREATE OR REPLACE PROCEDURE test
AS
v_output_file1 utl_file.file_type;
BEGIN
/* Ensure TEST_DIR below is in all caps */
/* Third argument below is W which overwrites file each time, change to A to append */
v_output_file1 := utl_file.fopen('TEST_DIR', 'my_test.csv', 'W');
FOR cursor_emp IN (SELECT empnom,ename, deptno FROM emp)
LOOP
utl_file.put_line(v_output_file1, cursor_emp.empno || ',' || cursor_emp.ename || ',' || cursor_emp.deptno);
END LOOP;
utl_file.fclose_all;
END;
/