Database and Filesystem integration

 Hello ...

I have some database procedures that create different text files. I need to create a file system structure to save this files. I can do this with utl_file_dir variable in init.ora. The problem is that I need more then 200 directories increasing every year,  so utl_file_dir is unsuitable.

I try to create  a root directory in utl_file_dir and creating my file system structure inside it, but it does not work. The database needs each directory in utl_file_dir. Example:

Option 1: The following does not work:

utl_file_dir = /myroot

So create files in /myroot/fc , /myroot/fd