Database Administration (MOSC)

MOSC Banner

ORA-29283: invalid file operation, WHEN UTL_FILE.INVALID_OPERATION on Oracle 11gR2

edited Jun 9, 2020 9:13AM in Database Administration (MOSC) 5 comments
 Dear Oracle,
I got the errors by an unknown chance. It happened on sometimes, and most time were OK.
Oracle database:version 11.2.0.3 at Windows 2008 R2.

ORA-06512: at "SYS.UTL_FILE", line 41
ORA-06512: at "SYS.UTL_FILE", line 512
ORA-29283: invalid file operation


Here my procedure,

...
v_fileName=:to_char(sysdate, 'mmddyyyy_hh24miss')||'.txt';
...
UTL_FILE.FOPEN ('My_mail', v_fileName, 'W',32767);
UTL_FILE.PUT_LINE (file_handle_msg, 'My Review started '||to_char(sysdate,'mm/dd/yyyy hh24mi')||'.');
UTL_FILE.FCLOSE (file_handle_msg);
...
EXCEPTION
...
WHEN UTL_FILE.INVALID_OPERATION
 THEN
 UTL_FILE.FCLOSE (file_handle_msg);

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