Re: Oracle / Postgres Interface - Mailing list pgsql-general

From Doug McNaught
Subject Re: Oracle / Postgres Interface
Date
Msg-id 874qlrv7ek.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to Oracle / Postgres Interface  ("Shah, Sameer" <SShah@vicr.com>)
Responses Re: Oracle / Postgres Interface
List pgsql-general
"Shah, Sameer" <SShah@vicr.com> writes:

>     1. I have DataBase-A which is Oracle on Server A with FunctionA
>        (PLSQL)
>     2. I have DataBase-B which is Postgress on Server B with FunctionB
>        (PgSQL)
>     3. I need to call FunctionA from FunctionB

As far as I know, the on'y way to do this is to write a Postgres
function (function B) in C that links with the Oracle client libraries,
connects to Oracle, and calls your function A.

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863

pgsql-general by date:

Previous
From: "Shah, Sameer"
Date:
Subject: Oracle / Postgres Interface
Next
From: Greg Stark
Date:
Subject: Re: Oracle / Postgres Interface