I have a variable returned from Oracle SQL Function which holds file names.
I would like to test if all the file names mentioned in the string exists in a directory. If all the files exists print "exists", even if one file does not exists print "Does not exists".
Since you are using Oracle anyway, Oracle has a built in package called utl_file. You can use the FGETATTR
Procedure in utl_file to check if the file exists and handle the errors if a file does not exist. You just need to
have a database directory point to where the files are.