UTL_FILE.FRENAME ORA-29283: invalid file operation
I'm trying to debug a UTL_FILE concurrent program that is suppose to copy a file from one and create it with a different name in another directory within the same drive on LINUX server. Below is what my code looks like; this program used to work but all of a sudden it just started throwing this invalid operation error. The environment is Linux, DB 10.2.0.3; tested appl owner has write permission to both directories, concurrent manager should have permission:
-rwxr-x--- 1 applgld dba 601 Jan 29 07:54 CM_PRICE_UPLOAD_CHANGE_20100120_TEST.csv
BEGIN
-- move file to the processed directory
UTL_FILE.FRENAME (