First, define the schema of the database that will be called into :
Next, create the schema of the database that will make the remote procedure call :
Now, an insert into the "one_table" table will fire a trigger that calls "one_procedure" which is a remote procedure call to the "two_procedure" stored procedure on the other database, which will insert the same values into the "two_table" table.
3
I'd like to add that thoughts on exception handling are very recommended here: In case the second database might be unavailable, an insert in the first database will fail as the call to one_procedure() will fail. That will rollback the according transaction. That may or may not be acceptable.
(15 Apr '11, 10:19)
Volker Barth
|