PL/SQL Error for UTL_FILE

[saw15]

Working with a stored procedure, and just started getting the following error:

WHEN UTL_FILE.INVALID_OPERATION THEN
RAISE_APPLICATION_ERROR(-20102, 'UTL_FILE: INVALID OPERATION.');
UTL_FILE.FCLOSE_ALL();
RETURN;


I am looking for any information on this error, what may cause it? Why it just started popping up, etc.


Thanks

 

[VSU]

[tt]
...
WHEN UTL_FILE.INVALID_OPERATION THEN
UTL_FILE.FCLOSE_ALL(); -- 1. Close all files and 2. RAISE user exception
RAISE_APPLICATION_ERROR(-20102, 'UTL_FILE: INVALID OPERATION.');
-- RETURN; -- Not needed 'cause unhandled user exception will stop program execution.
[/tt]
Check UTL_FILE_DIR initialization parameter is set properly.

 

[jee]

I don't know if this is helpful, but this is what the Supplied Packages manual says about this exception:

INVALID_OPERATION
File could not be opened or operated on as requested.

I might check things like permissions on the file/folder/directory first. Perhaps some permissions have been changed.

 

[saw15]

Very helpful .. thank you patrons.