Postgres Pro
Downloads
Home   >   mailing lists

Thread: Oracle / Postgres Interface

Oracle / Postgres Interface

From
"Shah, Sameer"
Date:
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Hi All,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">I would appreciate any input on this dilemma:</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial"> </span></font><ol start="1" type="1"><li class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;   font-family:Arial">I have DataBase-A which is Oracle on Server A with FunctionA
(PLSQL)</span></font><liclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Ihave DataBase-B which is Postgress on Server B with FunctionB (PgSQL)</span></font><li
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt;    font-family:Arial">I need to call
FunctionAfrom FunctionB</span></font></ol><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">I don’t mind rewriting PgSQL to some other language in Postgress if need be.</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Can I do this? If Yes, How?</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Please reply as soon as possible.</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Thanks,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Sameer</span></font></div>

Re: Oracle / Postgres Interface

From
"Goulet, Dick"
Date:
Sameer,
 IF you've got Java installed it might work that way via jdbc.


-----Original Message-----
From:    Shah, Sameer
Sent:    Tue 9/21/2004 12:57 PM
To:    pgsql-interfaces@postgresql.org
Cc:
Subject:    [INTERFACES] Oracle / Postgres Interface
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