Re: handling special characters in sqlldr

From: shakespeare <whatsin_at_xs4all.nl>
Date: Thu, 09 Sep 2010 23:11:15 +0200
Message-ID: <4c894d75$0$22938$e4fe514c_at_news.xs4all.nl>

Op 9-9-2010 18:11, dmardkar schreef:
> Hi,
>
> 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:
>
>
> load data
> infile "./scrhlp.dat" "str X'400A'"
> badfile "./scrhlp.bad"
> into table scrhlp_rec
> fields terminated by "|"
> (
> HLP_LNG_CD ,
> HLP_FLD_NM ,
> HLP_LN_NO ,
> HLP_TXT ,
> HLP_REF_DT
> )
>
>
>
> 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.
>
> Thanks.

Make the column some chars longer.

Shakespeare Received on Thu Sep 09 2010 - 16:11:15 CDT