Spooling Oracle XML data results in 1 line and missing data?
You're probably hitting the default &quot;long&quot; data type display limit of 80 characters:

SET LONG {80 | n}
Sets maximum width (in bytes) for displaying CLOB, LONG, NCLOB and XMLType values; and for copying LONG values.