Re: Read file path from Oracle

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 04 Nov 2002 20:16:40 GMT
Message-ID: <3DC6D59D.11AB5DAD@exesolutions.com>

"laurent léturgez" wrote:

> Hi,
>
> I would like to insert into a table files from a filesystem.
> I have created my own PL/SQL procedure which insert a specified file (with
> full path) into a table with a BLOB column.
> My aim is to make this automatically. So, i want to know if I can execute an
> "ls command" and get all the full path of my files I want to insert !
> So, I you got an idea ... make me a sign !!
>
> Regards,
>
> Laurent

Look at Java stored procedures. Tom Kyte has a good example in his book "Expert one-on-one Oracle."

Probably also at http://asktom.oracle.com.

Daniel Morgan Received on Mon Nov 04 2002 - 14:16:40 CST