>Hello all!

>Is possible that one FB database connects to another FBdb and do some

inserts, updates or deletes ?

>I need to do this on PLSQL ...

>Help or advice is apreciated.

Hi

In Fb2.5 I'm using procedure like this:

SET TERM ^ ;

CREATE OR ALTER PROCEDURE INSERT_DATA
as
declare variable name email;
declare variable id integer;
declare variable constr email;
declare variable strsql email;
begin
constr = '192.168.0.27/3055:D:\Database\Almexa\External\test2.5.fdb';
strsql = 'Insert into T1 ("Id","Name") VALUES (?, ?)';
for select ID, NAME from T1
into :ID, :NAME
do
begin
EXECUTE statement (strsql) (:id, :name)
ON EXTERNAL DATA SOURCE constr
as USER 'SYSDBA' password 'masterkey' ;
end
end^

SET TERM ; ^

GRANT EXECUTE ON PROCEDURE INSEXT TO SYSDBA;

Regards,
Paul