APEX: Create My Downloads page showing large report files(downloadable) created in shared directory

APEX question:

I want to create a page where user can click on the report name link.

This will run a sql query and create a csv report file on the server in shared directory

Now I want to create a page showing all the report files that are in progress and are downloadable when completely loaded on server.

Creating a csv seems like going with utl package write o a directory.

Questions:

How can I make the APEX page show the files on the server in shared directory and make them downloadable for the user.

Help with a sample code is appreciated. Thank you