<div>
can u post your full .ctl file because i can try it it my system here.<br />
<br />
Thanks
</div>


can u post your full .ctl file because i can try it it my system here.

Thanks

<div>
<br />
@johnsone<br />
&gt;&gt;...if there are multiple delimiters, it treats it as 1 column.<br />
<br />
Never have I seen SQL*Loader treat consecutive delimiters as ONE.<br />
<br />

</div>



@johnsone
>>...if there are multiple delimiters, it treats it as 1 column.

Never have I seen SQL*Loader treat consecutive delimiters as ONE.



<div>
Only with the optionally enclosed by. &nbsp;That is the ONLY time I have ever seen that.
</div>


Only with the optionally enclosed by.  That is the ONLY time I have ever seen that.

<div>
Forced accept.<br />
<br />
Computer101<br />
EE Admin
</div>


<div>
<div class="content wysiwyg-content">
Hi All,<br />
My data file records looks like this<br />
95938,95940,12-23-2005,01-<wbr />26-2006,&quot;L<wbr />andmark VI CDO, Ltd.&quot;,Asset-Backed Securities,CDO,,,,310,6,B,<wbr />15000000,,<wbr />9.2,Aa2,AA<wbr />,,Floating<wbr />,,100.000,<wbr />,50.000,,L<wbr />ibor,,Othe<wbr />r Tranche Comments,Comments<br />
<br />
How can I load this file using sql loader <br />
I created the ctl file like this<br />
<br />
load data<br />
badfile /u01/sf_laod.bad'<br />
append<br />
INTO TABLE TT<br />
FIELDS TERMINATED BY &quot;,&quot; OPTIONALLY ENCLOSED BY '&quot;'<br />
TRAILING NULLCOLS<br />
(IGMSecurityID &nbsp;&quot;trim(:IGMSecurityID)&quot;,<br />
-----<br />
-----)<br />
<br />
It ingnore all the records<br />
saying &nbsp;ORA-01008: not all variables bound<br />
<br />
I think it is due to &nbsp;(&quot;) &nbsp;data &nbsp;have in ,&quot;Landmark VI CDO, Ltd.&quot; How can I solve this problem.<br />
Reply ASAP<br />
Thanks<br />
<br />
<br />
<br />

</div>
</div>


Hi All,
My data file records looks like this
95938,95940,12-23-2005,01-26-2006,"Landmark VI CDO, Ltd.",Asset-Backed Securities,CDO,,,,310,6,B,15000000,,9.2,Aa2,AA,,Floating,,100.000,,50.000,,Libor,,Other Tranche Comments,Comments

How can I load this file using sql loader 
I created the ctl file like this

load data
badfile /u01/sf_laod.bad'
append
INTO TABLE TT
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(IGMSecurityID  "trim(:IGMSecurityID)",
-----
-----)

It ingnore all the records
saying  ORA-01008: not all variables bound

I think it is due to  (")  data  have in ,"Landmark VI CDO, Ltd." How can I solve this problem.
Reply ASAP
Thanks





SQL lOADER(DATA FORMAT)

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.