0 Replies Latest reply on May 15, 2012 3:16 PM by Miroslav

    ApEx 4.1.1: update record in a view with 'instead of update' trigger

      I created a form against a view. The view is complex enough which prevents direct updates. To incorporate the update logic I created an 'instead of update' trigger on the view. When I open up the form, do changes, and click 'Apply Changes' button I am getting the following exception

      ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc.

      I understand that the standard 'Automatic Row Processing' process is trying to lock the record before updating using a cursor like

      select *
      from my_view
      for update

      and fails. Is it possible to bypass this locking while using the standard APEX processes?

      I think I can create a custom PL/SQL process which would execute the UPDATE statement (at least, it works in SQL*Plus), but I would like to know if I can use a standard ApEx functionality for this.