>I recall thatt there is a issue in using Buffers and Transaction together. Can someone enlighten me as to what the issue is and how to work around it.
>
>Thanks in advance.

You can't use TABLEREVERT() within a TRANSACTION.

work around , global revert with a:
ROLLBACK

Fabio