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

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Thu, 16 Jun 2005 23:29:51 +0200
Message-ID: <42b1ef50$0$340$ba620e4c@news.skynet.be>

<belda2010_at_hotmail.com> wrote in message news:1118954982.767035.227680_at_o13g2000cwo.googlegroups.com...
> Hello,
>
> I want to read files from a directory located outside the Oracle
> database server, using a pl/sql procedure. I have tried to do this
> operation using utl_file package and java storage procedures, no
> chance, it doesn't work.
>
> 1- Is it true that there is no way to access remote directories
> (located outside of the Oracle server) using an pl/sql procedure?
>
> 2- If so, please help! What can I do to get access to such directories
> from my pl/sql procedure?
>
> Thanks a lot.
> Belinda
>

Is this a UNIX or Windows server ? You could use rsh or ftp to read or get the remote files.

Matthias Received on Thu Jun 16 2005 - 16:29:51 CDT