cannot rollback in a distributes transaction

From: <amaranatha.reddy_at_gmail.com>
Date: 20 Dec 2004 07:53:33 -0800
Message-ID: <1103558013.183796.191320@c13g2000cwb.googlegroups.com>

Hi,
I am trying to execute a Remote procedure through Database link. Ex: DECLARE
verr varchar2(1000);
BEGIN
SP_TEST_at_DB1(verr);
END;
In the above example, I am connected to DB2 and am executing the Procedure in DB1 through the database link setup in DB2.

When I try to rollback a transaction in the remote procedure (sp_test), it is throwing an error saying "Cannot rollback in a distributed transaction". But i have no problem using COMMIT, in the remote procedure.

Can anybody help me out....

Regards,
Amar. Received on Mon Dec 20 2004 - 09:53:33 CST