5 Replies Latest reply: Jul 8, 2013 11:00 AM by Pramod SR RSS

    Audit details to show/highlight modified columns in forms

    Pramod SR

      Hi Experts,

       

       

      I am working on Oracle forms 10g (OS: Windows7) from last 1 year. I have got a requirement to show the history of table in forms. Now i need to highlight only the modified columns in a row using visual attribute. I have written a AFTER UPDATE database trigger in order to insert OLD values into a log table. In the trigger, to compare the values i have added IF condition to check OLD and NEW values and changed columns i am saving (comma separated) in a column in the same table. Again in POST-QUERY trigger i am applying the visual attributes. Suppose if i alter the main table then i have to modify the trigger accordingly. This is not dynamic. Is there any way we can make this process dynamic?

       

      Thanks,

      Pramod