Hi,

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

You either have to resort to a 3rd party tool, or create a pump
yourself. You can then schedule it via the Windows scheduler
service (or whatever OS you're using).

For example, Database Workbench ( www.upscene.com ) includes
a command-line datapump tool, with which you can use a previously
saved datapump-project (that includes table mappings etc) that can
be easily scheduled via the Windows task scheduler.


With regards,

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

>
> > 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]
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>