handling special characters in sqlldr - 09-09-2010 , 11:11 AM
I am trying to load a record(s) in a table which contains a field of
text datatype. The records in question contain occasional single
qoutes. This is an example of such records:
en|PRD-SHPE|11.0|NOTE: If a slab is a dummy', an asterisk is
displayed at the end of the|20011003.0|
I am then creating a control file and use sqlldr to load the data but
the load fails with the following messege:
Record 1: Rejected - Error on table SCRHLP_REC, column HLP_TXT.
ORA-12899: value too large for column
"RPSNX31"."SCRHLP_REC"."HLP_TXT" (actual: 75, maximum: 74)
Here is the control file I am using:
infile "./scrhlp.dat" "str X'400A'"
into table scrhlp_rec
fields terminated by "|"
If I remove the single qoute in the data, all works fine. How do I
specify that a single qoute is acceptable in this case? Please help.
Re: handling special characters in sqlldr - 09-09-2010 , 04:11 PM
Op 9-9-2010 18:11, dmardkar schreef:
Re: handling special characters in sqlldr - 09-09-2010 , 04:13 PM
On Sep 9, 12:11*pm, dmardkar <dmard... (AT) gmail (DOT) com> wrote:
text strings enclosed with ' or "? Using " my loads succeed.
Possibly you should change the enclosing quotation character for your