| load lob data using Length-Value Pair Fields [message #177788] |
Fri, 16 June 2006 09:56  |
AlinaC
Messages: 45
Registered: November 2005
Location: India
|
Member |
|
|
When trying to load lob data using Length-Value Pair Fields
getting error
error converting character length field to a number
sample .ctl and .dat file given below.
LOAD DATA
INFILE 'sample.dat' "str '<endrec>\n'"
INTO TABLE person_table
FIELDS TERMINATED BY ','
(name CHAR(25),
"RESUME" VARCHARC(3,500))
Datafile (sample.dat)
Johny Quest,479 Johny Quest
500 Oracle Parkway
jquest@us.oracle.com
... <endrec>
Speed Racer,000<endrec>
Why that error?
Regards,
Alina
|
|
|
|
| Re: load lob data using Length-Value Pair Fields [message #178592 is a reply to message #177788] |
Wed, 21 June 2006 12:37  |
AlinaC
Messages: 45
Registered: November 2005
Location: India
|
Member |
|
|
Resolved the error, actually .dat file was not correct, I have rectified my data file. But my purpose is not getting solved, when trying to load only one record is being inserted and returing messege Commit point reached - logical record count 1.
Do I need to express the string used as a record separator in hexadecimal notation If "\" escaping is not supported. How to resolve the issue?
Regards,
Alina
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
