procedure based block locking

Good morning,

I have a form block that is based on a procedure that passes a table of records in and out. This form is going to be used by multiple user looking at the same data so an on-lock procedure has been included as part of the package. This is working when user B tries to update the same record that user A is in the process of updating. I can catch the ora 00054 exception and prevent B from doing anything as long as the record is locked. What I have not figured out is how to force B to re-query the record after A has updated and committed it. Since the block data is stored in a pl/sql table it does not automatically pick up the changes so I can have a phantom update occur. Is there a standard way to handle this type of processing that I have not yet found? If so, could you point me in the right direction or provide some ideas on how you handle this?

Thanks Received on Sat Mar 20 2004 - 09:55:21 CST