I am facing a strange issue using my Oracle SQL developer as a client for a Oracle 11g database.
I have a plsql procedure that writes some report files using UTL_FILE package. If I run it from SQL developer it fails, with the following error:
CHAIN_LOG_ID="5205", STEP_NAME="STEP2", ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation
ORA-06512: at "SDG_CDR.MONTHLY_LOCATION_REPORT", line 37
If I run the same procedure directly on sql plus, it works fine and generates the report files. I have created the output directory from sql developer and it looks fine to me as it has been created as sys user.