Re: sqlldr and large text files

I counted 268 chars in your location data string. Could your actual ascii file be limited to a width of 255 ? I do know that if your data wrapped at the EOL, the CR and LF characters can confuse sqlldr. Try trimming the data string to 255 or less and test that format. If it works, you'll have to look into the sqlldr keyword "continueif" and do some formatting of your data prior to loading.

Cliff
cbuetikofer_at_isinet.com   Received on Thu Jun 26 1997 - 00:00:00 CEST