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, ...).

You cannot do that from within a stored procedure and UDFs should
be simple operations, not db connections.

If you're trying to transfer data, use a datapump.

With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com