Starting 18c, UTL_FILE_DIR Parameter is no longer supported and errors out if called. Instead we have to directly call the file object using utl_file. This is due to increase the security of the database, since UTL_FILE will use the DIRECTORY object as location where in the UTL_FILE_DIR is the direct path to the OS directory where you have no control on privilege.
This has been notified in 12c release that UTL_FILE_DIR will be removed and 18c is not going to support.
What it has for you?
- All of your scripts where referred to UTL_FILE_DIR may need revisit
- Application jobs using UTL_FILE_DIR referring may need revisit
- Add this one as your one of pre upgrade check list
Ref: Oracle 18c New Features.
-Thanks
Suresh
Follow Me!!!