Can anyone tell me if updating data using Prodatasets is compatible with oracle database ?
We have customers of our frameworks doing this, so I guess the answer is yes.
I couldn't think of any reason why this shouldn't work. The DATA-SOURCE uses by default unique keys to fetch the records to become updated. That should work pretty well with Oracle.