| simple sql loader question [message #365516] |
Tue, 01 September 1998 10:07  |
Kevin Rose
Messages: 6
Registered: September 1998
|
Junior Member |
|
|
Heres my problem: (by example)
I have the sequence 5678 in a flatfile. However this really represents 567.8 in reality and in the database i am creating. Can anyone tell me the statement to use with sql loader to load this correctly ?
Thanks ! :)
|
|
|
|
|
|
| Re: simple sql loader question [message #365519 is a reply to message #365518] |
Wed, 02 September 1998 10:14  |
Kevin Rose
Messages: 6
Registered: September 1998
|
Junior Member |
|
|
But how can I handle if the field doesn't contain a value. In the SQL table definition this field is optional.
I am getting a Error message: "Invalid zoned decimal nibble."
How can I handle cases where this field has no value in which i still want to load the rest of the data on that record.
|
|
|
|
| Re: simple sql loader question [message #365520 is a reply to message #365519] |
Wed, 02 September 1998 11:16 |
Steven Olson
Messages: 2
Registered: September 1998
|
Junior Member |
|
|
The SQL*Loader-641 error message generally means that the control file specifications do not match the datafile. Look in your logfile and see where the column sizes start to fail. My experience is that SQL*Loader will insert a null value without any problems, but if the columns are incorrect in the controlfile the result will be a load failure.
Also, the Oracle Server Utility Users Guide is a great reference for SQL*Loader. You should have a copy in HTML format on the install CD.
Good Luck!
SteveO
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
