ORA-00001:违反了唯一约束主键 [英] ORA-00001: unique constraint primary key violated
本文介绍了ORA-00001:违反了唯一约束主键的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
DELETE from dbo.T_LIAV_AGENT_STATE_APPROVAL SAP
WHERE EXISTS (SELECT UNIQUE 1 FROM MCS_SYNC_STATE_APPR APP
inner join MCS_SYNC_NAME SN on SN.SE_NAME_ID = APP.SE_NAME_ID
and SN.ACTION in('U','S')
Where APP.SE_name_id = SAP.AV_NAME_ID
and APP.SYNC_INSTANCE_ID = param_inst_ID);
COMMIT;
INSERT INTO dbo.T_LIAV_AGENT_STATE_APPROVAL
SELECT UNIQUE
APP.SE_NAME_ID AS AV_NAME_ID,
APP.STATE AS AV_STATE,
APP.APPROVAL_TYPE AS AV_APPROVAL_TYPE,
APP.START_DATE AS AV_START_DATE,
APP.END_DATE AS AV_END_DATE,
APP.APPOINTED AS AV_APPOINTED,
APP.RENEWAL_DATE AS AV_RENEWAL_DATE,
APP.LICENSE AS AV_LICENSE,
COMPANY_NAME_ID as AV_COMPANY_CODE,
SYSDATE AS TSTAMP,
SYNC_USER_NAME_ID AS AV_FIRST_USER_ID,
SYSDATE AS AV_FIRST_DATE,
NULL AS AV_LAST_USER_ID,
NULL AS AV_LAST_DATE
FROM MCS_SYNC_STATE_APPR APP
WHERE exists (select 1 from t_liag_agent AG
where AG.ag_name_id = APP.SE_NAME_ID)
and APP.SYNC_INSTANCE_ID = param_inst_ID;
这是SQL部分,调试代码时出现错误:
Here is the SQL part and I am getting error when I debug the code:
ORA-00001:在T_LIAV_AGENT_STATE_APPROVAL ...处违反了唯一约束主键...
ORA-00001: unique constraint primary key violated At T_LIAV_AGENT_STATE_APPROVAL...
,这是主键约束依赖于AV_NAME_ID, AV_STATE
的2列.
and these are the 2 columns which the primary key constraint relies on AV_NAME_ID, AV_STATE
..
我没有重复的数据...您认为还有其他原因吗?
There is no duplicate data as per me ...Do you think any other reason?
推荐答案
Select语句缺少一列,因此出现此错误.当我将该列添加到select语句中时,它运行良好.
Select statement was missing a column when compared to Insert table statement so there was this error. When i added that column to the select statement it worked perfectly.
这篇关于ORA-00001:违反了唯一约束主键的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文