PL/SQL (MOSC)

MOSC Banner

UTL_FILE.FRENAME ORA-29283: invalid file operation

edited Feb 10, 2010 3:15AM in PL/SQL (MOSC) 35 commentsAnswered
 Hi Experts,

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  (

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center