2

Recently, I encountered many UTL.FILE.WRITE_ERROR , but the doc does not explain all the causes.

For example: Oracle PL/SQL UTL_FILE.PUT buffering describes one situation that causes this issue that when we called put(even we fflush after every single char) to write to a file without new line terminator.

Hope to summarize the common causes for this error. Thank you!

Community
  • 1
  • 1
JaskeyLam
  • 15,405
  • 21
  • 114
  • 149

1 Answers1

1

The documentation explains that UTL_FILE.WRITE_ERROR is an exception that gets thrown on a Operating system error occurred during the write operation. So the exception has nothing to do with the UTL_FILE package itself but is thrown as a consequence of an OS related error that has occured. Based on the other exceptions that are thrown on more specific errors I would say that the two most common causes for a WRITE_ERROR exception are:

  • Out of space
  • File deletion during write operation
gvenzl
  • 1,861
  • 14
  • 22
  • 1
    Something is more tricky actually, please check http://stackoverflow.com/questions/7206312/oracle-pl-sql-utl-file-put-buffering – JaskeyLam Sep 02 '14 at 09:46