OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ORA-02047

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-02047 [message #54644]

Mon, 25 November 2002 09:19

rena
Messages: 8
Registered: November 2002

Junior Member

Hi,

I have used generic connectivity to conenct an Oracle and an MS Access database.

I have also created a trigger as follows:

CREATE OR REPLACE TRIGGER customer_increase AFTER INSERT ON CUSTOMER BEGIN INSERT INTO CUSTOMER@MYDB.WORLD VALUES(1,'ss','ss','ss',9); END;

but when i test it :

INSERT INTO CUSTOMER VALUES(1,'dd','dd','dd',8);

I am getting the errors:

ORA-02047: cannot join the distributed transaction in progress
ORA-06512: at "KARDITSI.CUSTOMER_INCREASE", line 1
ORA-04088: error during execution of trigger 'KARDITSI.CUSTOMER_INCREASE'

Does anyone know which is the error?

Thanks in advance
Maria

Report message to a moderator

Re: ORA-02047 [message #54655 is a reply to message #54644]

Tue, 26 November 2002 00:12

Maaher
Messages: 7065
Registered: December 2001

Senior Member

It means that a two-phase commit has failed in your (heterogeneous) environment. The remote db is the Access db I assume?

From the online docs at OTN:

Generic connectivity agents cannot participate in distributed transactions--they support single-site transactions only.

All this means that you either try to divide the transaction in a local and a remote part, or you have to buy a system-specific agent.

MHE

Report message to a moderator

Re: ORA-02047 [message #64159 is a reply to message #54655]

Thu, 23 December 2004 09:28

Saul Martinez
Messages: 3
Registered: December 2004

Junior Member

it means that it can be done by using transparent gateways?

Report message to a moderator

Previous Topic:	log file sync puzzle
Next Topic:	Any memory size limitations for users ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 24 23:18:06 CST 2025