Using SQL or PL/SQL it's not possible. The only way I'm aware of to do this from inside the database is JAVA. Search asktom, it's got a comprehensive example how to do this.
Currently I use Oracle 9. Is it true that in Oracle 10G it is
possibile to list directories content?