Solved

Oracle Multibyte issue

Posted on 2011-03-14
3
468 Views
Last Modified: 2012-05-11
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
||||||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.
0
Comment
Question by:Nakuru1234
  • 2
3 Comments
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
It would be the double slashes.

17 characters cannot fit into a 16 character column.

Do you want one slash in the field or none?
0
 

Author Comment

by:Nakuru1234
Comment Utility
Do you know what is causing the extra slash – that is the answer we are looking for on this one.

TIA,
N
0
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
Comment Utility
>>Do you know what is causing the extra slash

It has to be whatever you are using to extract the data to create the pipe delimited file.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now