> Hi,
> I am having difficulties with retrieving data from Oracle 10g into Fb2.1.
>
> My plan is to create a Stored Procedure in FB to retrieve data from Oracle
> 10g into FB, then massage the data and generate into a Management BI
> application.
>
> Can someone kindly tell me how to create the link to Oracle10g from FB and
> what is the syntax for these? Or should I use other tools to do this task?

You can't directly connect from Firebird to Oracle (or vice versa). You will need to write an application that connects to both and transfers the data. There might already be existing applications that do that, but since you need to 'massage' the data you can better do that in your own application.

Mark
--
GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT!
Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01