I've got Spool working in that the output from a query is returning everything, but after 500 characters, it starts a new line.
So if if I had a line that was 502 characters ending with 'bananasarecool', then it would look something along the lines of :
bananasareco
ol
So Spool isn't truncating or removing any data, but simply starting a new line.
I am using the following settings. Is there anything I need to change to output without a limit to a single line?
SET PAGESIZE 0
SET LINESIZE 32767
SET TRIMSPOOL ON
SET FEEDBACK OFF
SET COLSEP '|'
SET TERMOUT OFF
SET VERIFY OFF
SET FLUSH OFF
SET BUFFER LENGTH 4000
SET ARRAYSIZE 200
SET LONG 10000