Hi,
I am trying to execute a Remote procedure through Database link.
Ex: DECLARE
verr varchar2(1000);
BEGIN
SP_TEST@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.