原因:我向主键中传入重复的值,导致主键值违反唯一性
create_sql = “DECLARE i NUMBER(8);”
"BEGIN "
“SELECT count(*) into i FROM USER_ALL_TABLES WHERE TABLE_NAME=’” + tableName + "’; "
"IF i=0 then "
"execute immediate ‘CREATE TABLE " + tableName + "(LINE_ID VARCHAR2(50) ,EQP_ID VARCHAR2(50) ,SEQ NUMBER(10) PRIMARY KEY,PROCESS_DATA_NAME VARCHAR2(50),MEASURE_DATA VARCHAR2(50) ,PROCESS_DATA_VALUE VARCHAR2(50),DATA_TYPE VARCHAR2(50) ,COMPONENT_ID VARCHAR2(50))’; "
"END IF; "
“END;”
解决方法:删除主键。这样就不会导致插入时会主键重复