Attempting to Write CLOB Data Larger Than 32KB Using UTL_FILE Fails With: ORA-29285
(Doc ID 358422.1)
Last updated on MARCH 28, 2019
Applies to:PL/SQL - Version 10.1.0.3 and later
Information in this document applies to any platform.
***Checked for relevance on 14-Jun-2017***
UTL_FILE.PUT is used to write a CLOB data of more than 32KB in a text file.
The procedure fails with "ORA-29285: file write error" on UTL_FILE.FCLOSE().
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document