I need to call a procedure of a database from other database with trigger. Can you send me a example script?. Thank you.
asked 15 Apr '11, 09:13
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.