mtzcsc opened a new issue, #6972: URL: https://github.com/apache/seatunnel/issues/6972
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/seatunnel/issues?q=is%3Aissue+label%3A%22bug%22) and found no similar issues. ### What happened An error is reported for data synchronization Caused by: java.sql.BatchUpdateException: ORA-01461: 仅能绑定要插入 LONG 列的 LONG 值 ### SeaTunnel Version 2.3.4 ### SeaTunnel Config ```conf # Defining the runtime environment env { parallelism = 2 job.mode = "BATCH" } source{ Jdbc { url = "jdbc:oracle:thin:@ip:1521/ORCL_1" driver = "oracle.jdbc.OracleDriver" user = "c" password = "" query = "select ORG_CODE JGBM , PERSON_ID HZWYBS ,'1' DATA_SOURCE, '1' OPERATIONFLAG ,'' JKDABM , NVL(substr(replace(INS_PROP_CODE,'无',''),0,2),'9') HZYBLXBM ,IDCARD KH ,'' KLX ,'' FKDQ ,'0' HZLX ,NVL(IDCARD_TYPE_CODE,'01') SFZJLBBM ,NVL(trim(IDCARD),'000000000000000000') SFZJHM ,substr(NAME,0,10) HZXM ,replace(SEX_CODE,'无','') XBBM ,DATE_OF_BIRTH CSRQ ,'' NLDW ,TEL DHHM ,TEL SJHM , '-' DZYJDZ ,'-' XLBM ,replace(CITIZENSHIP_CODE,'无','') GJBM ,replace(NATION_CODE,'无','') MZBM ,replace(MARITAL_CODE,'无','') HYZKBM , CONTACT_NAME LXRXM from caching2.TM_OUT_PERSON_INFO p where rksj>=trunc(sysdate-3)" } } transform { # If you would like to get more information about how to configure seatunnel and see full list of transform plugins, # please go to https://seatunnel.apache.org/docs/transform-v2/sql } sink { Jdbc { url = "jdbc:oracle:thin:@ip:1521/ORCL_1" driver = "oracle.jdbc.OracleDriver" user = "" password = "" generate_sink_sql = "true" database = "ORCL" table = "EHR2.HZJBXXB" enable_upsert = "true" primary_keys = [JGBM, HZWYBS, DATA_SOURCE, OPERATIONFLAG] #schema_save_mode = "CREATE_SCHEMA_WHEN_NOT_EXIST" } } ``` ### Running Command ```shell Invoked via DS ``` ### Error Exception ```log Caused by: java.sql.BatchUpdateException: ORA-01461: 仅能绑定要插入 LONG 列的 LONG 值 ``` ### Zeta or Flink or Spark Version _No response_ ### Java or Scala Version _No response_ ### Screenshots   ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@seatunnel.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org