OraFAQ Forum: Server Administration » Trigger Err (Insert into another DB)

Home » RDBMS Server » Server Administration » Trigger Err (Insert into another DB)

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

Trigger Err (Insert into another DB) [message #52931]

Wed, 21 August 2002 02:00

Pixie Tan
Messages: 3
Registered: June 2002

Junior Member

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;

Report message to a moderator

Re: Trigger Err (Insert into another DB) [message #52935 is a reply to message #52931]

Wed, 21 August 2002 04:35

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

1. if you have the microsoft transaction options turn
   them off.
2. Make sure, the DML u are using is not causing a
   commit inside a trigger.

Report message to a moderator

Previous Topic:	ORA-01033 ERROR!!!!!!!!!!!
Next Topic:	question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 13:28:48 CDT 2024