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 to cvs file creates blank rows

768863May 4 2010 — edited May 4 2010

Hello, I am trying to create a spool file to a csv file. i am able to create the csv file successfully, but every 14 rows there is a blank row. This will cause a problem since we will have another application reading this file and most likely error out when it reaches the blank row.

I have a batch fiile that is calling a sql file that runs the script that produces the spool. We are using oracle 10g, release 10.2.0.4.0

I have tried different options with the spool but nothing seems to help. here is an example of my result
1-1011S6
1-101HGX
1-1027Y
1-108FAP
1-108FDP
1-10BJB
1-10CIIU
1-10K6QD
1-10NNY5
1-10P5G9
1-10PTI5
1-10RAY
1-112DI

1-115PEP
1-118PAO
1-12KWI
1-142UB
1-14CJ3
1-14CM7
1-14D2R
1-14LJU
1-14LRN
1-14RWV
1-14WEW
1-15239
1-15276

1-152YQ
1-1539N
1-153NO
1-1541D

any ideas would be great.
Thanks in advance

This post has been answered by odie_63 on May 4 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 1 2010

Added on May 4 2010

#file

5 comments

2,507 views