Home » SQL & PL/SQL » SQL & PL/SQL » Trigger connect to different database?
Trigger connect to different database? [message #21360] Mon, 29 July 2002 23:09 Go to next message
Susan
Messages: 102
Registered: October 2001
Senior Member
How do we code an AFTER INSERT,UPDATE,DELETE trigger on current database table that would makes changes to a table in a

-> different database, same server
AND/OR
-> different database, different server ?

Please help.

Report message to a moderator

Re: Trigger connect to different database? [message #21363 is a reply to message #21360] Tue, 30 July 2002 05:06 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
use a dblink! something like this
create or replace trigger trig1
after insert on emp
for each row
begin
insert into mag.emp@mydblink
values (.........);
end;

Report message to a moderator

Previous Topic: can i execute the sqlldr from inside the plsql procedure
Next Topic: creating and calling procedures
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 00:06:29 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.