When I try to load .txt data into oracle, it give me the following message, I checked on line, one of posting showing me to get rid of comma, looks it is not right solution to my case. I also post one of problem raw data here, fyi. pls help. thanks in advance!!!
tarting job ig_letter at 17:09 05/10/2010.
connecting to socket on port 3857
connected
connecting to socket on port 4339
connected
Exception in component tFileInputDelimited_1
java.lang.NumberFormatException
at java.math.BigDecimal.<init>(Unknown Source)
at java.math.BigDecimal.<init>(Unknown Source)
at routines.system.ParserUtils.parseTo_BigDecimal(ParserUtils.java:131)
at jim.ig_letter_0_1.ig_letter.tFileInputDelimited_1Process(ig_letter.java:2758)
at jim.ig_letter_0_1.ig_letter.runJobInTOS(ig_letter.java:3732)
at jim.ig_letter_0_1.ig_letter.main(ig_letter.java:3599)
disconnected
disconnected
Job ig_letter ended at 17:09 05/10/2010.
here is two of problem raw data, fyi.
939818|Wayne & Blandine|Mr. & Mrs. Hardman|Mr. & Mrs. Hardman||1023137|2191993|E|PO BOX 24, GROUP 305|RR 3|||BEAUSEJOUR|MB|R0E0C0|Canada|Mail|2|Client |Accepted|1.57|19624|M|E|RAYMOND|PADUA|B.Comm Hons, CFP|Financial Consultant|Conseiller
938165|MR TIMOTHY GADDE AND MRS NANCY HUYNY-LO|MR TIMOTHY GADDE AND MRS NANCY HUYNY-LO|MR TIMOTHY GADDE AND MRS NANCY HUYNY-LO||1021555|2188466|E|ITF NATHAN WILLIAM GADDE|270 PICKFORD DR|||KANATA|ON|K2L3T5|Canada|Mail|2|Client |Accepted|1.57|2128|M|E|PAUL|VAILLANCOURT|CFP CSA CLU|Sr. Exec. Financial Consultant|Conseiller financier émérite principal|6137428018231|88|paul.vaillancourt@investorsgroup.com|430 - 1730 St. Laurent Blvd.||||Ottawa|ON|K1G5L1|Investors Group Financial Services Inc.||Services Financiers Groupe Investors Inc.||||||||||||||
