I started to get Oracle error ORA-22816: unsupported feature with RETURNING clause after upgrade from 11.3.2 to 11.4.3.
When I have a view on a single table for instance:
Code: Select all
create view v_odac_clob as
select * from odac_clob
Code: Select all
create or replace trigger t_v_odac_clob
instead of insert or update or delete on v_odac_clob
for each row
begin
if inserting then
insert into odac_clob(code, title, value)
values
(:new.code, :new.title, :new.value);
end if;
if updating then
update odac_clob u
set u.code = :new.code,
u.title = :new.title,
u.value = :new.value
where u.code = :old.code
and u.title = :old.title;
end if;
if deleting then
delete from odac_clob u
where u.code = :old.code
and u.title = :old.title;
end if;
end t_v_odac_clob;