Re: Connecting to an other source from Oracle

Did you try out views with functions? Where the function contains the odbc-call.
eg: create view yourview as (select function(columnvalue) columna from tablea);
Of course you will allways need a driving table, unless you select from dual.

Anyway, I do not think it's such a good idea to access your eul via such a layer.
Isn't there a way to replicate/condense your data to the oracle database first?

Arkzoyd <arkzoyd_at_my-deja.com> schreef in berichtnieuws 876op0$et9$1_at_nnrp1.deja.com...
> I managed to connect to an ODBC source from within the Oracle database
> using an external procedure.
>
> I'd like to use this external procedure to extract data and use them
> with Oracle Discoverer. I tried to find a way to make a link between a
> REF Cursor and something I could use in Discoverer. But it looks like
> the is nothing similar than Forms "block based on a procedure"
>
> Does someone find a way to access an ODBC source without storing the
> EUL in the same database ?!
>
> Thanks you for your Help !
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Feb 01 2000 - 21:11:44 CET