Nakuru1234
asked on
Oracle Multibyte issue
There are several records that have a backslash at the end of a column which causes the load file to look like:
31082443130126091998|00000 0420411200 12000|0710 1001202090 8\\|660175 278|1|0.0| 0.0|20|ACC OUNT 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|A SL52C|2000 -01-20 00:00:00|11.04.42|F|GUAR RH LOAN DFLT STATUS
||||||65930656031918121996 |
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?
TIA,
N.
31082443130126091998|00000
00:00:00|0.0|2000-01-19 00:00:00|2000-01-10 00:00:00|68613.96|496.44|A
||||||65930656031918121996
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?
TIA,
N.
ASKER
Do you know what is causing the extra slash – that is the answer we are looking for on this one.
TIA,
N
TIA,
N
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
17 characters cannot fit into a 16 character column.
Do you want one slash in the field or none?