Subject RE: [firebird-support] Access to Oracle from Firebird
Author Vuignier Eric
Thanks a lot for your answer, but I would like to transfer dynamically i.e.
the transfer will occur automatically (scheduler) once or twice a day and
this transfer should select the value to transfer. Can I make that
dynamically with a datapump ?

-----Original Message-----
From: Martijn Tonies [mailto:m.tonies@...]
Sent: mercredi, 13. août 2003 13:15
Subject: Re: [firebird-support] Access to Oracle from Firebird


> 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 <>

Yahoo! Groups Sponsor


374-105951838331032> click here


To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to the Yahoo!
<> Terms of Service.

[Non-text portions of this message have been removed]