Skip to Main Content
Forums

Oracle Database Discussions

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!

Facing ORA-01722 error while trying to insert data using ctl file

3427576Nov 17 2017 — edited Nov 17 2017

Hi,

This is the CTL file

pastedImage_0.png

This is the dataset I want to insert

pastedImage_1.png

This is the error I am facing

pastedImage_2.png

This is the structure of the table

pastedImage_4.png

I am using sqlldr to insert the data in the csv file to a db table. all these scripts are called by a shell script. I understand the issue is with the data format but not able to find the actual root cause. Kindly help me out in solving this.

Thanks!!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 15 2017
Added on Nov 17 2017
#general-database-discussions
11 comments
483 views