Oracle XMLfunctions Puts Linebreak after 2000 Characters in Spooled Output (Doc ID 1101433.1)

Last updated on JULY 07, 2010

Applies to:

SQL*Plus - Version: 10.2.0.4 and later   [Release: Oracle10g and later ]
Information in this document applies to any platform.

Symptoms

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.


Cause

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