>
>Since this will require the opening and closing of many, many tables in at two differnt sites, and the creation and destruction of multiple cursor, I am wondering if it is even practical.

This may not be a good idea. If I remember right all tables are locked for everyone while you are in a transaction.

Good Luck