The Toad Script Output and Quest Scriptrunner output line is too long.
Â
To reproduce the problem please follow the steps below:
Run the following script in Toad 10.5 and in Quest Script Runner:
set linesize 500
set pagesize 30000
set heading off
set feedback off
set recsep off
set timing off
set trimout on
set trimspool on
set define off
set echo off
spool C:\tmp\Test.lst
select table_name from dba_tables where owner='SYS' and rownum < 10 order by table_name;
spool off
open file Test.lst (for example notepad ++, Ultraedit...)
Â
You wil have this :
CCOL$
CDEF$
CON$
FET$
FILE$
PROXY_DATA$
PROXY_ROLE_DATA$
TS$
UNDO$
Â
If you select the text above you will see that there are blanks after every file (this should not happen as we have set trimspool on)
If you run the very same script with SQL Plus, the result is:
Â
CCOL$
CDEF$
CON$
FET$
FILE$
PROXY_DATA$
PROXY_ROLE_DATA$
TS$
UNDO$
Â
without blanks at the end of every column (as expected).
