Hi,
I am trying to Archive some kind of historization within an Apex enviroment.
Therfore I created two tables LCM_BDT$ACT and LCM_BDT$HIST with the same structure and a view LCM_BDT based on that tables.
The view is created with
Select * from LCM_BDT$ACT UNION ALL SELCT * FROM LCM_BDT$HIST.
Then I am trying to create a "instead of trigger" for insert update and delete.
The trigger is working in SQL but if I try it within Apex I got a ORA-0214.
Any ideas ?
Thank you