Subject Re: [ib-support] Connect to DB from Procedure ??
Author Paul Reeves
Damian Dowling wrote:
> Hi
> Is it possible to connect to Database B from a Procedure in
> Database A, e.g.
> from within a procedure:
> CONNECT 'c:\Program Files\Firebird\isc4.gdb' USER 'SYSDBA'
> PASSWORD 'masterkey';

No. You can only use DML statements (select, insert, update, delete) in
stored procedures.

Of course, if you like living dangerously you could write a UDF to do
the job, but I wouldn't recommend it in a multi-user database.

What is it you are trying to achieve?


Paul Reeves
taking InterBase further