Subject Re: [firebird-support] Update remote database table via stored procedure
Author Moegamat Alexander

You think that would be a likely feature in future. It is a feature
that oracle has for a long time called database links and it comes
in very handy

>>> Helen Borrie <helebor@...> 2007/11/13 01:07 pm >>>
At 08:14 PM 13/11/2007, you wrote:
>Is there way to update a table that resides in another database via a
>stored procedure?

Not directly: one database cannot be a client to another. You need an
application to mediate between the two.

Place the SP in the database that is to be updated; write a selectable
SP or a query in the source database; have your application pick up the
output from the source query and pass it to the target SP via
parameters, all inside a single, cross-database transaction.

Replication applications often use stored procedures in this way.

Some DB Admin tools, e.g. IB_SQL (amongst others) provide "data
pumping" utilities that allow you to do the same thing.