Re: How to Read Files Located Outside the Oracle Server Using PL/SQL

Hi Belinda,

Just a suggestion that may be worth looking into:

If you have Oracle on the other machine where you want to read the files, then maybe you
can still use UTL_FILE (I have not tried it) in a stored procedure that is executed via a database
link?

You could have a link going both ways, where by your procedures or functions can write the
results back to a table at the callers end?

Alternatively, you can look into VBScript. It allows you to execute scripts remotely from your local machine - Have a look at MSDN
for the finer details.

Hope this help's.
Chris Val Received on Thu Jun 16 2005 - 16:54:11 CDT