Oracle / Postgres Interface

[Shah, Sameer]

Hi All,



I would appreciate any input on this dilemma:



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



I don't mind rewriting PgSQL to some other language in Postgress if need
be.



Can I do this? If Yes, How?



Please reply as soon as possible.



Thanks,

Sameer

[Doug McNaught]

Re: Oracle / Postgres Interface

"Shah, Sameer" <SShah@vicr.com > writes:
[color=blue]
> 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[/color]

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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to majordomo@postg resql.org)

[Greg Stark]

Re: Oracle / Postgres Interface


Doug McNaught <doug@mcnaught. org> writes:
[color=blue]
> "Shah, Sameer" <SShah@vicr.com > writes:
>[color=green]
> > 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[/color]
>
> 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.[/color]

If performance isn't an issue it might be faster to get going using a PerlU
function in Postgres that uses DBD::Oracle to connect to Oracle.

It's the same thing but you don't have to learn two new C APIs. If you already
know how to use Pro*C and the postgres C API then there's probably no benefit.

--
greg


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings