Com. ibatis. common. jdbc. exception. nestedSQLException: --- The error occurred in --- The error occurred while applying a parameter map. --- Check the outwhbill. insertDtlHis-InlineParameterMap. --- Check the statement (update failed ). www.2cto.com --- Cause: java. SQL. SQLException: ORA-01722: invalid number problem is:
1. The table structure is updated. The DTL table and DTL_HIS table have the same structure but different locations. Why is the alter execution sequence problem? SQL code SQL> desc TBL_DTL; Name Null? Type verification -------- Invalid version number (10) multi_1_varchar2 (2) invalid VARCHAR2 (40) EXPIRE_DATE_TO VARCHAR2 (40) LVCARD_ID VARCHAR2 (13) LVCARD_TYPE VARCHAR2 (20) FR_ALERT_VAL NUMBER (10) SQL code SQL> desc tbl _ dtl_his; Name Null? Type verification -------- Invalid version not null number (10) multi_1_varchar2 (2) FR_ALERT_VAL NUMBER (10) 1_varchar2 (40) EXPIRE_DATE_TO VARCHAR2 (40) LVCARD_ID www.2cto.com VARCHAR2 (13) LVCARD_TYPE VARCHAR2 (20) 2. during the insert statement, the SQL code insert into table_dtl_his (select * from table_dtl where BILL_NO = # billNo #) is used; 3. if any problem is found, run desc tabl In the e_dtl and table_dtl_his tables, the location of the FR_ALERT_VAL attribute is different. As a result, the queried number is inserted into the varchar field.
4. Solution: SQL code insert into partition (select VERSION, multi_second, FR_ALERT_VAL, interval, EXPIRE_DATE_TO, LVCARD_ID, LVCARD_TYPE from TBL_DTL where BILL_NO = # billNo #) prepared by xly1981