ORA-01465: invalid hex number报错原因,有个blob类型!
insert into t_info (CUSTOMER_NO, PASSPORT_ID, IS_REALNAME, NAME, IS_REQUEST_CERTIFICATE, GRADE, TYPE, REGISTER_TYPE, PRODUCT_NO, MOBILE_PHONE, EMAIL_ADDRESS, LOGIN_ID, NICK_NAME, PINKEY, IVR_PINKEY, QUERY_PINKEY, GENDER, ID_TYPE, ID_NO, HOME_PHONE, OFFICE_PHONE, OTHER_PHONE, APANAGE, AREA_CODE, CITY_CODE, CONTACT_ADDRESS, CONTACT_ZIPCODE, UNIT_ADDRESS, UNIT_ZIPCODE, PWD_ERR_NUM, LOCK_TIME_LIMIT, UNIT_CODE, QUESTION, ANSWER, ACTIVE_ADDRESS, ACTIVE_CODE, ACTIVE_STATUS, REGISTER_TIME, PORTRAIT, IS_CLOSED, ACCEPT_ORG_CODE, ACCEPT_UID, MANAGER, LAST_SUCCESS_LOGIN_TIME, LAST_SUCCESS_LOGIN_IP, LAST_FAIL_LOGIN_TIME, LAST_FAIL_LOGIN_IP, LAST_UPDATE_TIME, STATUS, CLOSE_TIME, ACTIVE_TIME_LIMIT, ACTIVE_TIME)
values ('8899000000019505', '', '3', '8899000000019505', '0', '3', 'B', 'B', '8899000000019505', '', '', '', '', '33B6FACBC5B6E283A01E7607BAF1C785', '33B6FACBC5B6E283A01E7607BAF1C785', '33B6FACBC5B6E283A01E7607BAF1C785', '9', 'X', '8899000000019505', '', '', '', '002110000010000', '999900', '999900', '', '', '', '', 0, '', '', '', '', '', '', '2', '28-6月 -11 05.46.58.000000 下午', '', '0', '001999900000000', '', '', '', '', '', '', '28-6月 -11 05.49.33.545000 下午', '1', '', '', '')
ORA-01465: invalid hex number
insert into t_info (CUSTOMER_NO, PASSPORT_ID, IS_REALNAME, NAME, IS_REQUEST_CERTIFICATE, GRADE, TYPE, REGISTER_TYPE, PRODUCT_NO, MOBILE_PHONE, EMAIL_ADDRESS, LOGIN_ID, NICK_NAME, PINKEY, IVR_PINKEY, QUERY_PINKEY, GENDER, ID_TYPE, ID_NO, HOME_PHONE, OFFICE_PHONE, OTHER_PHONE, APANAGE, AREA_CODE, CITY_CODE, CONTACT_ADDRESS, CONTACT_ZIPCODE, UNIT_ADDRESS, UNIT_ZIPCODE, PWD_ERR_NUM, LOCK_TIME_LIMIT, UNIT_CODE, QUESTION, ANSWER, ACTIVE_ADDRESS, ACTIVE_CODE, ACTIVE_STATUS, REGISTER_TIME, PORTRAIT, IS_CLOSED, ACCEPT_ORG_CODE, ACCEPT_UID, MANAGER, LAST_SUCCESS_LOGIN_TIME, LAST_SUCCESS_LOGIN_IP, LAST_FAIL_LOGIN_TIME, LAST_FAIL_LOGIN_IP, LAST_UPDATE_TIME, STATUS, CLOSE_TIME, ACTIVE_TIME_LIMIT, ACTIVE_TIME)
values ('8899000000019505', '', '3', '8899000000019505', '0', '3', 'B', 'B', '8899000000019505', '', '', '', '', '33B6FACBC5B6E283A01E7607BAF1C785', '33B6FACBC5B6E283A01E7607BAF1C785', '33B6FACBC5B6E283A01E7607BAF1C785', '9', 'X', '8899000000019505', '', '', '', '002110000010000', '999900', '999900', '', '', '', '', 0, '', '', '', '', '', '', '2', '28-6月 -11 05.46.58.000000 下午', '', '0', '001999900000000', '', '', '', '', '', '', '28-6月 -11 05.49.33.545000 下午', '1', '', '', '')
ORA-01465: invalid hex number
置为空就可以了:
insert into t_info(CUSTOMER_NO, PASSPORT_ID, IS_REALNAME, NAME, IS_REQUEST_CERTIFICATE, GRADE, TYPE, REGISTER_TYPE, PRODUCT_NO, MOBILE_PHONE, EMAIL_ADDRESS, LOGIN_ID, NICK_NAME, PINKEY, IVR_PINKEY, QUERY_PINKEY, GENDER, ID_TYPE, ID_NO, HOME_PHONE, OFFICE_PHONE, OTHER_PHONE, APANAGE, AREA_CODE, CITY_CODE, CONTACT_ADDRESS, CONTACT_ZIPCODE, UNIT_ADDRESS, UNIT_ZIPCODE, PWD_ERR_NUM, LOCK_TIME_LIMIT, UNIT_CODE, QUESTION, ANSWER, ACTIVE_ADDRESS, ACTIVE_CODE, ACTIVE_STATUS, REGISTER_TIME, PORTRAIT, IS_CLOSED, ACCEPT_ORG_CODE, ACCEPT_UID, MANAGER, LAST_SUCCESS_LOGIN_TIME, LAST_SUCCESS_LOGIN_IP, LAST_FAIL_LOGIN_TIME, LAST_FAIL_LOGIN_IP, LAST_UPDATE_TIME, STATUS, CLOSE_TIME, ACTIVE_TIME_LIMIT, ACTIVE_TIME)
values ('8899000000019505', '', '3', '8899000000019505', '0', '3', 'B', 'B', '8899000000019505', '', '', '', '', '33B6FACBC5B6E283A01E7607BAF1C785', '33B6FACBC5B6E283A01E7607BAF1C785', '33B6FACBC5B6E283A01E7607BAF1C785', '9', 'X', '8899000000019505', '', '', '', '002110000010000', '999900', '999900', '', '', '', '', 0, '', '', '', '', '', '', '2', '28-6月 -11 05.46.58.000000 下午', '', '0', '001999900000000', '', '', '', '', '', '', '28-6月 -11 05.49.33.545000 下午', '1', '', '', '')
insert into t_info(CUSTOMER_NO, PASSPORT_ID, IS_REALNAME, NAME, IS_REQUEST_CERTIFICATE, GRADE, TYPE, REGISTER_TYPE, PRODUCT_NO, MOBILE_PHONE, EMAIL_ADDRESS, LOGIN_ID, NICK_NAME, PINKEY, IVR_PINKEY, QUERY_PINKEY, GENDER, ID_TYPE, ID_NO, HOME_PHONE, OFFICE_PHONE, OTHER_PHONE, APANAGE, AREA_CODE, CITY_CODE, CONTACT_ADDRESS, CONTACT_ZIPCODE, UNIT_ADDRESS, UNIT_ZIPCODE, PWD_ERR_NUM, LOCK_TIME_LIMIT, UNIT_CODE, QUESTION, ANSWER, ACTIVE_ADDRESS, ACTIVE_CODE, ACTIVE_STATUS, REGISTER_TIME, PORTRAIT, IS_CLOSED, ACCEPT_ORG_CODE, ACCEPT_UID, MANAGER, LAST_SUCCESS_LOGIN_TIME, LAST_SUCCESS_LOGIN_IP, LAST_FAIL_LOGIN_TIME, LAST_FAIL_LOGIN_IP, LAST_UPDATE_TIME, STATUS, CLOSE_TIME, ACTIVE_TIME_LIMIT, ACTIVE_TIME)
values ('8899000000019505', '', '3', '8899000000019505', '0', '3', 'B', 'B', '8899000000019505', '', '', '', '', '33B6FACBC5B6E283A01E7607BAF1C785', '33B6FACBC5B6E283A01E7607BAF1C785', '33B6FACBC5B6E283A01E7607BAF1C785', '9', 'X', '8899000000019505', '', '', '', '002110000010000', '999900', '999900', '', '', '', '', 0, '', '', '', '', '', '', '2', '28-6月 -11 05.46.58.000000 下午', '', '0', '001999900000000', '', '', '', '', '', '', '28-6月 -11 05.49.33.545000 下午', '1', '', '', '')
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27573546/viewspace-762545/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/27573546/viewspace-762545/