The insert statement is as follows:
insert into ctr_dlr (
MKT_CO,
CTR_DLR,
NAME,
ADDR1,
ADDR2,
STATE,
CITY,
ZIP_CODE,
REF_ZIP,
PHONE_NO,
OC_STAT,
CTR_DLR_FLAG,
MAINT_DATE,
CTR_DLR_5CHAR,
DTE_SOFT_INSTALL,
SOFT_VERSION,
CLASS,
DATE_OPEN,
DATE_CLOSED,
AFM_RTE_NUM,
MAIL_ADDR,
MAIL_CITY,
MAIL_ST,
MAIL_ZIP,
CPL_LBL_IND,
BKUP_WITHHOLD_FLG,
CPL_LBL_NUM,
HYPERION_ID,
RESERVE,
MAINT_DATE_8,
DATE_OPEN_8,
DATE_CLOSED_8)
values (
781,
1090,
'USA COLLISION CENTERS',
'',
'905 N RAILROAD AVE',
'FL',
'BOYNTON BEACH',
'33435',
'33424',
5617321832,
'O',
'D',
180913,
1090,
0,
0,
'1',
20180913,
0,
'001',
'905 N RAILROAD AVE',
'BOYNTON BEACH',
'FL',
'33435',
'L',
'N',
1,
'',
'',
20180913,
20180913,
0)
When I try to run this through Java, I get the following error:
java.sql.SQLException: ca.datacom.db.DBSQLException: ca.datacom.db.DBSQLException: OVERFLOW: TYPE<UNUMERIC(6,0)> ACTION<ASSIGNMENT/CONVERSION> in Session(executeImmediate)in Session(executeImmediate)
at ca.datacom.jdbc.DatacomJdbcObject.getSQLException(Unknown Source)
at ca.datacom.jdbc.DatacomStatement.execImmediate(Unknown Source)
at ca.datacom.jdbc.DatacomStatement.executeUpdate(Unknown Source)
at db.common.runSQL(common.java:394)
at db.CommonConnection.runSQL(CommonConnection.java:176)
at test.testDatacom.main(testDatacom.java:34)