-
9i external tables - reading file from the network
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
-
os is win2k
forgot to add i am using win2k OS
-
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;
/
I'm stmontgo and I approve of this message
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|