Hi,

At August 13, 2003, 02:37, Vuignier Eric wrote:

> Hi,

> I evaluate the firebird db (try to replace the MS SQL Server DB by the
> Firebird DB) and I would like to know if it is possible to access an Oracle
> DB (select values in the Oracle DB and insert them in the Firebird DB) from
> within a stored procedure of firebird (udf, ...).

Unfortunately, not at the present time, by using the native PSQL
language. I don't know in which version that would be possible.

But, it might be possible with a UDF and an external table. Because
an UDF can't return a full result set, you can use a UDF to prepare an
external table by extracting the data from Oracle and then within the
stored procedure select from the external table. External Table(or
File) is a fixed length ASCII file. One thing to remember, you can't
use BLOBs.

Another option, might be to have an external application that performs
what you want, and maybe have the UDF execute the application. You
can have the application automatically close after it finishes, so
there wouldn't be any user interaction required.

Hope this gives you some ideas.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)