I've scripts where UTL_FILE.FOPEN
is used and the parameter passing for directory is an absolute path i.e., /asr/file/path
and the corresponding oracle directory name as ASR_ABC
but after up-gradation to oracle 19c the parameter is expected to be direcotry name ASR_ABC
instead of absolute path /asr/file/path
.
If I pass an absolute path I get error as Invalid path
.
Do I have to change all the files from absolute path to directory name? or is there any work around which can be done from database to avoid changes in all files?
Best Answer
Starting with 18c, the
UTL_FILE_DIR
parameter no longer exists, thus the usage of directory paths instead of directory objects inUTL_FILE
is no longer possible.Desupport of UTL_FILE_DIR Initialization Parameter
Even in earlier releases, the parameter and usage of paths existed only for backward compatibility.