Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting error while loading csv file to oracle table

ARIVEMULA KAVYA KUMARI LERA TECHNOLOGY PVT LTDOct 27 2015 — edited Oct 28 2015

Hi,

I am tryitng to load csv file to oracle db table.

Source:

Csv file have account_numbers, customer_names. all fields, it taken as string.

Target:Oracle db

If i taken all fields as varchar, its loading fine. but i want

Oracle table fields : account numbers as number format or decimal (20,2)

customer_names as varchar2 format.

when i am trying to load csv to oracle table, i am getting following error.

ODI-1228: Task fgh1 (Integration) fails on the target ORACLE connection odi_user1.

Caused By: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

I have tried so many times. still i am getting error.

to_number function also i used,even getting error

Please help me,

Thanks & Regards,

A.kavya.

This post has been answered by ARIVEMULA KAVYA KUMARI LERA TECHNOLOGY PVT LTD on Oct 28 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 25 2015

Added on Oct 27 2015

#business-intelligence-applications, #data-integrator, #error, #odi, #oracle, #system-management-and-integration

8 comments

1,268 views