06-09-13, 07:25 #1Registered User
- Join Date
- Oct 2010
Unanswered: sqlloader not loading into Clob field, help required please
Wanted to load the positional flat file data into 2 columns and the entire row into 3rd column which is defined as CLOB datatype.
create table orginfo(
Orgname varchar2(4000 byte),
Secorgname varchar2(4000 byte),
Sample record info of datafile attached.
Control file information:
INTO TABLE orginfo
FULLRECINFO ":ORGNAME || ECORGNAME "
It is throwing the error specified below:
SQL*Loader-309: No SQL string allowed as part of FULL_REC_INFO field specification
When modified the control file alternatively as per below code also to no avail:
TO_CLOB( ":ORGNAME || ECORGNAME" )
SQL*Loader-350: Syntax error at line 7.
Expecting valid column specification, "," or ")", found "TO_CLOB".
FULL_REC_INFO TO_CLOB( ":ORGNAME || ECORGNAME " ).
Could anyone please provide a solution to it. I have got struck on this and need to solve this asap.
Thanks & Regards,
06-09-13, 10:58 #2Registered User
Provided Answers: 1You can lead some folks to knowledge, but you can not make them think.
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.