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
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Access to Oracle from Firebird

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 <http://www.upscene.com>





Yahoo! Groups Sponsor


ADVERTISEMENT

<http://rd.yahoo.com/M=259538.3705203.4965331.1261774/D=egroupweb/S=17051153
86:HM/A=1712983/R=0/SIG=11u38u3s2/*http://hits.411web.com/cgi-bin/hit?page=1
374-105951838331032> click here


<http://us.adserver.yahoo.com/l?M=259538.3705203.4965331.1261774/D=egroupmai
l/S=:HM/A=1712983/rand=450252126>

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.


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