Error while Loading data.....
Posted: Wed Jun 30, 2004 4:35 am
Hi All,
I have got a huge set of legacy data on a DVD for one of the legacy system and I need to FTP the data on to the UNIX box,
1. When FTPing the data I get a problem when I FTP it in ASCII mode but no issues when I FTP the data in BINARY mode.
I checked both the cases and both have a Carriage return character (^M)
2. then inorder to remove the control character ,I used EREPLACE(data,char(13),'') then I found that there were " added so I used a EREPLACE to remove the quotes and also spaces.
3. Then When I run the Job the runs and is aborted i get the folowing error,nls_read_delimited() - row 375630, too many columns in record
4. when I do a count against the source file, the count seems to be equal.
Please let me know what needs to be done.
Any help would be appreciated.
Thanks & Regards
SMK
I have got a huge set of legacy data on a DVD for one of the legacy system and I need to FTP the data on to the UNIX box,
1. When FTPing the data I get a problem when I FTP it in ASCII mode but no issues when I FTP the data in BINARY mode.
I checked both the cases and both have a Carriage return character (^M)
2. then inorder to remove the control character ,I used EREPLACE(data,char(13),'') then I found that there were " added so I used a EREPLACE to remove the quotes and also spaces.
3. Then When I run the Job the runs and is aborted i get the folowing error,nls_read_delimited() - row 375630, too many columns in record
4. when I do a count against the source file, the count seems to be equal.
Please let me know what needs to be done.
Any help would be appreciated.
Thanks & Regards
SMK