Subject Re: [firebird-support] Update remote database table via stored procedure
Author Helen Borrie
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.