Trigger Err (Insert into another DB)

[pixietan]

I was trying to do an application which will delete the records at a scheduled time. Upon deletion, a trigger will be triggered to do an insert to a table of another DB. However, I was prompted an error "ORA-02041:client database did not begin a transaction". I had created and tested the DBLink. Can anybody advise? Thanks in advance.

CREATE OR REPLACE TRIGGER "Ouser"."TINSERT_T" AFTER DELETE
ON "Ouser"."CL"
FOR EACH ROW BEGIN
insert into test@DB1 values ('1');
end;

[mkumarnk]

ORA-02041 client database did not begin a transaction

Cause: An update occurred at a coordinated database without the coordinatorbeginning a distributed transaction. This may happen if a stored procedurecommits and then performs updates, and the stored procedure is invoked
remotely. It could also happen if an external transaction monitor violates the XA protocol.

Action: If the cause is the former, check that any commit is not followed by an update.