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.

What version of Oracle on what platform? Is sp_test an anonymous
transaction or a regular transaction?

Generally speaking the commit or rollback you are attempting in sp_test
should be executed in the code on DB1 after the return from sp_test
based on the return from sp_test. That is if sp_test encounters an
error it should return the error code to its remote caller and let the
caller determine what to do.

HTH -- Mark D Powell --

Most likely you are on 8i or below. Check bug id 1347296 on the
Metalink. This is fixed in 9i.

Regards
/Rauf