子查询没有重复仍然报错oracle01427

报错代码:
update instrument i set i.repayer_id=(
select distinct party_id from instrument_party p
where p.instrument_id=i.instrument_id
and p.party_role_id=''R
)

https://blog.csdn.net/AskTommorow/article/details/59110391

update instrument i set i.repayer_id=(
select distinct party_id from instrument_party p
where p.instrument_id=i.instrument_id
and p.party_role_id=''R
)
where exists(select 1 from instrument_party p
where p.instrument_id=i.instrument_id
and p.party_role_id=''R)
可以这样试试