spool truncating the output ??
558772Apr 23 2008 — edited Apr 24 2008i'm trying to spool some data but it seems that some of the lines of the output are truncated ??.
i'm something like
SET NEWPAGE 0
SET SPACE 0
SET LINESIZE 9999
SET PAGESIZE 0
SET ECHO OFF
SET FEEDBACK OFF
SET VERIFY OFF
SET HEADING OFF
SET MARKUP HTML OFF
SET TRIMSPOOL ON
SELECT <my_columns> ..........
the characters inside that table are mostly arabic characters so i couldn't test in
command line sqlplus bcoz output is scrambled but i did test with sqldeveloper and toad
and the query seems to generate the desired output.
i am sure that the lines the query generates are nothing near 9999 chars long.
is there any option from the ones i'm using that might be causing this.
please advise