DG4MSQL ORA-12899 on Insert Error After Upgrading DG4MSQL to 11.2.0.1.0 from 11.1 (Doc ID 1146263.1)

Last updated on JULY 16, 2010

Applies to:

Oracle Database Gateway for SQL Server - Version: 11.2.0.1 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms


=== ODM Issue Clarification ===

Using the Oracle Database Gateway for Microsoft SQL Server 11.2 (DG4MSQL)
on HP-UX Itanium 11.31 with Oracle Server 11.2.0.1
an insert into table from SQL Server 2005 fails with error
ORA-12899: value too large for column "BERM"."ADR"."POB_LBX_IND" (actual: 3,maximum: 1)

The insert statement is -

Insert into ADR (SWH_GK, ADR_ID, STR_TXT, POB_LBX_IND, UPD_DT ,WHS_PULL_DT)
select SWH_SEQUENCE.NEXTVAL,"AddressId","StreetTxt","POBoxLockboxInd","UpdateDt","UpdateDt"
from "Address"@EXP2
where "AddressId" < 2654;

and the error is -


select SWH_SEQUENCE.NEXTVAL,"AddressId","StreetTxt","POBoxLockboxInd","UpdateDt"
,"UpdateDt"
*
ERROR at line 2:
ORA-12899: value too large for column %s (actual: %s, maximum: %s)
ORA-02063: preceding line from EXP2

the describe of the SQL*Server table from Oracle is -


SQL> desc "Address"@EXP2;
Name                                  Null?                Type
----------------------------------------- -------- 
AddressId                          NOT NULL          NUMBER(10)
UpdateDt                           NOT NULL          DATE
StreetTxt                                                         VARCHAR2(50 CHAR)
POBoxLockboxInd                                         CHAR(1 CHAR)


The Oracle table is created as -


create table ADR (
SWH_GK NOT NULL NUMBER(19)
ADR_ID NOT NULL NUMBER(19)
UPD_DT NOT NULL DATE
STR_TXT NVARCHAR2(50)
POB_LBX_IND NVARCHAR2(1)


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms