Hi,
I am reading from Unix Sequential file - fixed width format and
writing to Oracle table.
I am getting an error while I am writing to the table.
LoadStage.MPNO.InRecord: read_fixedwidth() - row 53161308, column TXT, column unexpectedly ended by EOR
The total number of records in the input file are 63161900.
How do I find the error record?
Thanks
Ketfos
EOR character
Moderators: chulett, rschirm, roy
A reject link would work, or you can just believe the error message that row 53161308 has the issue. I'm guessing you've got an embedded high ascii character, probably a linefeed.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle