Oracle Multibyte issue
Posted on 2011-03-14
There are several records that have a backslash at the end of a column which causes the load file to look like:
31082443130126091998|00000042041120012000|071010012020908\\|660175278|1|0.0|0.0|20|ACCOUNT DELINQUENT|1999-10-01 00:00:00|2000-01-10
00:00:00|0.0|2000-01-19 00:00:00|2000-01-10 00:00:00|68613.96|496.44|ASL52C|2000-01-20 00:00:00|11.04.42|F|GUAR RH LOAN DFLT STATUS
The error am getting seems to indicate the problem with the multi-byte issue:
Record 2455477: Rejected - Error on table SFHG_LOAN_STAT_RPT, column SVCR_ACCT_NBR.
ORA-12899: value too large for column SVCR_ACCT_NBR (actual: 17, maximum: 16)
However, the column is defined properly:
SVCR_ACCT_NBR VARCHAR2(16 CHAR)
I’m wondering if it is the backslashes in the load file that is causing a problem. It shouldn’t because the \\ should be interpreted as a single backslash. The data does indeed have a backslash in it although it is for the same loan key. Any thoughts on this one?