During a project I had a requirement that may be considered as a future enhancement.

Basic use case, I would like to pick up records marked as 0 and set them to 1 as done, in my logic in the rest of the 
BPEL I will try and push the picked up record to various web services. If unsuccesfull (with whatever logic I tried to 
execute – ie logical error not system error) I want to go back to the database and set it to 2. All this I can do 
myself, the BC does not have to do this.

My problem is, when the BC now polls the table again, it picks up all the records that have the value of 0 or 2, I only 
want it to check for records of the value 0.

All I want from the BPEL is to only poll records where the parameter is 0 and set it to 1 once picked up. If the value 
in the MarkColumn field is anything other than 0 it should ignore it (2,3,4, etc.)