>>Where you read this?
>>I use SP rarely and i am not aware of this?
>>Just remove this block from my example and try it w/o error handling.
>
>I meant to say that when you call a SP via Ole DB you can't use TRY/CATCH syntax. This is what one of guys from VFPT confirmed here. It would be great to be able to use TRY/CATCH in SP from Ole DB.

If you have other copies of the database somewhere, can you check them as well. There is a possibility that the wrong table was updated.