用otl向表中插入数据出错,ORA-00001: 违反唯一性约束,但是数据库并不存在主键重复记录, 同样的SQL语句在 SQLPLUS里就可以插入成功,不知道解决,求教各位了```
ORACLE 10g
表
CREATE TABLE device_list
(
dev_id VARCHAR2(37) CONSTRAINT dev_list_pk PRIMARY KEY,
dev_name VARCHAR2(32) NOT NULL,
dev_ip VARCHAR2(32),
dev_mac VARCHAR2(32),
ccenter_addr VARCHAR2(32),
dev_type_id VARCHAR2(38) NOT NULL,
father_id VARCHAR2(37) NOT NULL,
sms_id VARCHAR2(37) NOT NULL,
reg_time DATE NOT NULL,
status VARCHAR2(10),
re VARCHAR2(255)
);
SQL:
INSERT INTO device_list(dev_id,dev_name,dev_ip,dev_mac,ccenter_addr,dev_type_id,father_id,sms_id,reg_time,status) VALUES('AD84A37D-6B47-45BD-A050-7369955FAA6F','N.S.M.S','192.168.1.21','00:1d:09:15:e7:c0','192.168.1.21','01','06F28ED8-E78D-4ED4-B424-ECE597A39212','AD84A37D-6B47-45BD-A050-7369955FAA6F', SYSDATE,'01050')
ORACLE 10g
表
CREATE TABLE device_list
(
dev_id VARCHAR2(37) CONSTRAINT dev_list_pk PRIMARY KEY,
dev_name VARCHAR2(32) NOT NULL,
dev_ip VARCHAR2(32),
dev_mac VARCHAR2(32),
ccenter_addr VARCHAR2(32),
dev_type_id VARCHAR2(38) NOT NULL,
father_id VARCHAR2(37) NOT NULL,
sms_id VARCHAR2(37) NOT NULL,
reg_time DATE NOT NULL,
status VARCHAR2(10),
re VARCHAR2(255)
);
SQL:
INSERT INTO device_list(dev_id,dev_name,dev_ip,dev_mac,ccenter_addr,dev_type_id,father_id,sms_id,reg_time,status) VALUES('AD84A37D-6B47-45BD-A050-7369955FAA6F','N.S.M.S','192.168.1.21','00:1d:09:15:e7:c0','192.168.1.21','01','06F28ED8-E78D-4ED4-B424-ECE597A39212','AD84A37D-6B47-45BD-A050-7369955FAA6F', SYSDATE,'01050')
如果在form里面就有問題了啊,應為form里面的數據塊如果用向導做的話,原來的表即使沒有主鍵約束,但是在FROM里的數據塊會默認一個item的唯一性約束的!你只要找到這個item,然后把屬性改一下就可以啊!