I tried to code nothing in on-update, and hoping this will override the built-in update function. But there is no update sign as insert or delete sign. So everytime, when I change sth, then I have to click save, I got error "frm-40501: oracle error: unable to reserve record for update or delete" the displayed error is: "ora-01445: can not select ROWID from a join view without a key-preserved table."
How to handle that?
Is there any trigger that can be fired before save. Then first we can customize our code to update the underlying table, then raise a trigger exception to avoid doing save?
Thank you a million!
How to handle that?
Is there any trigger that can be fired before save. Then first we can customize our code to update the underlying table, then raise a trigger exception to avoid doing save?
Thank you a million!