6 Replies Latest reply on Oct 15, 2013 11:28 AM by Hari_639

    Detect whether items on a form has changed in an After Submit PL/SQL Process

    Rmach-Oracle

      Hi,

       

      I have a simple form on a table. This form contains a hidden item whose value should be set in an After Submit Computation or PL/SQL Process only if any of the input fields in the form have been changed by the user. What is the easiest and most efficient way to detect whether the values in the form have been changed? I tried comparing the values in the form with the values in the database using an additional select query and this achieves the result that I am after but was thinking that there has to be a more efficient way of doing this without the additional query.

       

      Regards,

      Rupesh