SQLPLUS Spool - Truncating Data
I am running a SQL script in Solaris 9 to export data from an Oracle DB using spool. However, for one particular field, the data is getting truncated. Can anyone explain why this is happening or how I can fix it??
14Oct06 1459L/LC[[Called the helpdesk call center for update. They forwared me to the monitoring center. The monitoring center states that their ticket isnt closed yet.
My SQL script
14Oct06 1459L/LC[[Called the helpdesk call center fo
set heading off
set feedback off
set pagesize 0
set linesize 30000
set trimspool off
ORDER BY ENTRY_ID ASC;
Did you try:
col text_field format a1000
this space intentionally left blank
I just tried that and it still gives the same results
Last edited by ignignokt; 11-15-2006 at 03:30 PM.
Is it a LONG or a CLOB or something?
Set long 10000
The SET long 10000 seemed to work well, but it caused another problem. I use * for column seperators and it seems that it puts * whenever the data starts on a new line.
14Oct06 1459L/LC[[Called the helpdesk call c *
enter for update. They * forwared me to the monitoring * * center. The mon *itoring center states that their ticket isnt c* * losed yet.
Last edited by ignignokt; 11-15-2006 at 05:03 PM.
Click Here to Expand Forum to Full Width