On 1/30/06, M.Godlewski <mcgodlewski_at_yahoo.com> wrote:
>
> Oracle 9iR2
> Sun Solaris
> Once I add substr(a.description,1,4000) to my select clause from the
> table, I seem to get page breaks where they are not wanted.
> ...
> If anyone has ideas or docs I would appreciated the help! I imagine it is
> a sql limitation of some sort.
>
There are CR/LF line terminators in the data coming from SQL Server.
Modifying the DTS job to filter them would be the easiest method to correct,
especially if the SQL Server DBA is someone other than yourself.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 31 2006 - 09:21:15 CST
