Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL*Loader - ORA-01722 error

Status
Not open for further replies.
saira78

saira78

Technical User
Jan 14, 2003
40
0
0
CA
I'm hoping for some tips here. I'm using SQL*Loader to load some 2200+ records into a table and running into this problem for the modcnt field:

The control file reads:

modcnt DECIMAL EXTERNAL

The datatype in the table is:

MODCNT NUMBER

and when I start to load the file, I get this error in the log file (I'm testing with a few random records from the 2200 and each have the same error):

Record 1: Rejected - Error on table LC_F, column MODCNT.
ORA-01722: invalid number

Any help is greatly appreciated. Thanks,
Saira
 
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
172
Andrzejek
Andrzejek
Rasheed Shaik
  • Locked
  • Question
\Orant\DBS\FMCUS.MSG not found
Replies
0
Views
220
Rasheed Shaik
Rasheed Shaik
TheLazyPig
  • Locked
  • Question
Inserting Text Decimal to Table Error
Replies
4
Views
182
carp
carp
Livia8
  • Locked
  • Question
SQL SELECT - where date is null or greater than 2
Replies
9
Views
1K
carp
carp
mibeach7
  • Locked
  • Question
OEM extract ORA- from string text 1
Replies
2
Views
66
mibeach7
mibeach7

Part and Inventory Search

Sponsor

Back
Top