Oracle XMLfunctions Puts Linebreak after 2000 Characters in Spooled Output (Doc ID 1101433.1)
Last updated on JULY 07, 2010
SQL*Plus - Version: 10.2.0.4 and later [Release: Oracle10g and later ] Information in this document applies to any platform.
When trying to use Spool command to get data from XML tables to a flat file, the maximum line length gets limited to 2000 characters. After 2000 characters, it puts the 'next line' character. In short, SQL*Plus truncates or splits XMLType columns after 2000 bytes.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a Million Knowledge Articles and hundreds of Community platforms