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!

UTL_FILE displaying one extra line while reading and writing

user13424229Apr 19 2011 — edited Apr 20 2011

HI all,

I am using UTL_FILE to read and write data from a flat file in PL/SQL, but while i am reading it from flat file one extra line coming and also when i am writing one extra line is coming after the first line please help me on this.

in my first line the following data is there

EX.CCM001 000001 0952401950039 P09 0000004781311010DR 69849008D21103211000005802001 001 0000000000000000AL 00000000000000000000000000000000BP9999999 13801393

while i am reading and writing the data , above line is coming and one extra line is coming as below.

ex: BP9999999 13801393

thanks in advance
Deb

Locked Post

New comments cannot be posted to this locked post.

Locked on May 18 2011

Added on Apr 19 2011

5 comments

1,119 views