Subject Re: [firebird-support] Access to Oracle from Firebird
Author Martijn Tonies

> 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
> DB (select values in the Oracle DB and insert them in the Firebird DB)
> 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