APEX

Greetings All,

Any comments, assistance, links, or even answers on the following situation would be much appreciated....

I have a Application Express 4.0 (Could upgrade to 4.1 if it would help this issue)

I have a wizard generated tabular form on a table, the form will show up to 600 records (rows) on a page.

Part 1:
The situation:

User 1: Opens the form and brings up latest data set.
User 2: Opens the form and brings up the latest data set.
User 1: Changes data for record 1
User 1: Hits submit. The data is saved.
User 2: Changes data for record 1
User 2: Changes data for record 2
User 2: Hits submit. The following error is produced:

Error in mru internal routine: ORA-20001: Error in MRU: row= 1, ORA-20001: ORA-20001: Current version of data in database has changed since user initiated update process. current checksum = "3EE15D666E9DBDC59D34CE4CFB3950C0", item checksum = "922DA12AE1E3D8856695745C4D2830D2"., update "<Removed> Error Unable to process update.

When this error occurs no updates get made to the table.

I understand that row 1 can not be updated, however I would like row 2 (and all other rows where there is no conflict) to be updated. I would then like to be able to highlight in the form the rows that failed to update (And reload the data in them from the DB).

Is this something I can achieve using my own MRU procedure, or in another way?
Can anyone point me to a good example, tutorial or book showing how to do this.

Thanks!