I have the requirement that multiple application instances retrieve data from a table and process them. There is no pre-defined criteria to ensure that a record can be retrieved only by one instance.
The approach thought of is to retrieve the next 100 (say) records, change the status to a value indicating the it is under process and return it.
How best this can be achieved using cursors?