UTL_FILE access to subdirectories

[jad]

Ok ... i have a directory on my server, that i have mounted as a read only file system, this directory has documents in it that i'd like the Oracle server to be able to read ...

in my init<SID>.ora file i currently have each directory under this mapped as so:

UTL_FILE = /<mount>/docs
UTL_FILE = /<mount>/docs/docs1
UTL_FILE = /<mount>/docs/docs2
UTL_FILE = /<mount>/docs/docs3

or similar ...

any way of changing this so that i can add extra subdirectories easily

i've tried :

UTL_FILE = /<mount>/docs/*

but it doesn't work, and i don't want to do a :

UTL_FILE = *

cos this allows access to everything, including the oracle kernel, and i don't want anyone accessing that

any help would be useful ...

Jon

 

[karluk]

I'm fairly sure that this is a limitation of Oracle. The utl_file_dir parameter only allows * as a wildcard to allow access to everything. I don't think you can use it to provide access to a set of subdirectories.

 

[jad]

i thought so, but it is always worth asking


the number of subdirectories is increasing all the time