sqlloader help!!!

From: Steve <schen_at_prodigy.net>
Date: Wed, 6 Oct 1999 19:05:11 -0400
Message-ID: <7tgkde$2bee$1@newssvr03-int.news.prodigy.com>

Hi, All;

I have a problem to load a txt file with a large amout of delimited rows into an Oracle table. One Oracle column datatype is number, while the txt file has negative sign to stand for negative number after loading. The loading failed because it tried to load into the number column. However, if Oracle column datatype was changed to varchar2, the loading was successful.

What is the problem and how to get around it?

Your great help is appreciated.

Steve Received on Wed Oct 06 1999 - 18:05:11 CDT