Datacom

  • 1.  insert data into a table - getting error message:

    Posted Sep 17, 2018 04:46 PM

    getting the following error message trying to insert data into a table:

    OVERFLOW: TYPE<UNUMERIC(6,0)> ACTION<ASSIGNMENT/CONVERSION>



  • 2.  Re: insert data into a table - getting error message:
    Best Answer

    Posted Sep 17, 2018 04:49 PM
      • 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)



  • 3.  Re: insert data into a table - getting error message:

    Posted Sep 17, 2018 05:04 PM

    We saw our error...

     

    Thank you