Re: sql loader problem in 8.1.6

From: <zaferaktan_at_my-deja.com>
Date: Tue, 07 Nov 2000 19:05:13 GMT
Message-ID: <8u9jp2$t9m$1@nnrp1.deja.com>

FYI,
It ended up as a Oracle bug in 8i and 9i (Oracle tested on 8.2 also). Here is the problem. If you are using the CONCATENATE and WHITESPACE in your Sql*Loader control files, the concatenate function does not interpret the end of line as a whitespace. Therefore if you have a record on multiple lines in your ascii file which you are combining during the load to create the logical record, the concatenate will not recognize the end of line as a whitespace and you will end up with sql*loader errors. If this is a batch job - your whole load will be screwed. As a quick workaround I used the following in my korn shell script and it solved the problem.

sed -e 's/$/ /g' ${load_prefix_name}.tbl > ${load_prefix_name}.tbl_new;

best regards to all

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 07 2000 - 13:05:13 CST