Re: BFiles and Directory listings

In article <1003343610.28241.0.nnrp-12.9e984b29_at_news.demon.co.uk>, "Jonathan says...
>
>
>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).
>

well, not to kill sales (maybe this little nugget will help you decide the other pages are worth buying) but you can look at

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:439619916584

its there as well. It was the Java Stored procedures chapter - right after external routines in C.   

>--
>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.
>
>

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp