SQLPLUS Spool - Truncating Data

[ignignokt]

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.

Example:

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.