| Numbe Format for SQL*LOADER [message #73388] |
Thu, 08 April 2004 12:12 |
san
Messages: 11
Registered: October 2001
|
Junior Member |
|
|
Hi:
Version of SQL*Loader : Release 9.2.0.4.0
Oracle DB version : 9.2.0.4.0
Data File
000001500-A
000000810-B
000000000 C
000012222 D
Control File
LOAD DATA
REPLACE INTO TABLE test1
(
FIELD1 POSITION (1:10) CHAR "TO_NUMBER(:FIELD1,'099999999MI')",
FIELD2 POSITION (11:11)
)
The first two records are loading but it is giving error from 3rd record. It is not accepting "blank" space as positive.
(Which it should because of the number format 099999999MI)
Please share your thoughts and experiences.
TIA.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
