Hi,
I had this kind of issue. The solution I found was to use a view with a 'Instead of' trigger (available from Oracle 8) on it.
e.g:
--table
create table SY_T1 (
c1 number,
c2 varchar2(100)
);
-- view
create view SY_V_T1
as
select * from SY_T1;
--trigger on view
create or replace trigger...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.