Re: BFiles and Directory listings

Get hold of Tom Kyte's book:

    Export one on one: Oracle
    Wrox Press.

This has the full code of exactly the routine you need as part of the demo on using Java.

(I think it was the Java chapter, maybe it was the extproc demo though - whichever, it's there).

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.

Ranjan wrote in message ...


>I need to write a stored procedure that will load all files in a

>directory, one by one into BFILEs.  More specifically all the files

>with a certain extension.  How do I get a listing of all the directory

>files?  Is there a way to do so in PLSQL?  Need to do it for NT and

>Unix.

>

>Thanks.