Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

spool truncating the output ??

558772Apr 23 2008 — edited Apr 24 2008
i'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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 22 2008
Added on Apr 23 2008
4 comments
7,096 views