Skip to Main Content

E-Business Suite

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!

How to remove space after the last record

gkthomasJun 4 2019 — edited Feb 9 2021

I am using a SQL Loader concurrent program to load a  data from data file.  I am using #EOR# string as an end of the record marker  in order to handle CR and LF in the column data.  All my data loading fine . However at the end of the file ( after the last record)  there is a white space (CR or LF) . This space is going as a record and the SQL loader discard.  As a result I get a warning in Concurrrent program . Even though I do not lose any data, this warning is annoying. How can I handle this in Oracle Control File?  Please help.  sample given below

column one   Columntwo    #EOR#

3434              customer 1   #EOR#

4544              customer 2   #EOR#

6565              customer 3   #EOR#

space.....space...space ....

George

Comments

Post Details

Added on Jun 4 2019
3 comments
75 views