This is a multi-part message in MIME format.

--bound1109794465
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 7bit



<span style="font-family: verdana,arial,helvetica,sans-serif;">It isn't clear to me exactly what you mean here - do you mean via one of the embedded languages? <br /><br style="font-family: verdana,arial,helvetica,sans-serif;" /></span><span style="font-family: verdana,arial,helvetica,sans-serif;">I have not done that with an Oracle connection but I imagine it's straight froward with the right libraries<br />- in plPython for example.  I too would like to hear about any experience/issues with that.</span><br style="font-family: verdana,arial,helvetica,sans-serif;" /><br style="font-family: verdana,arial,helvetica,sans-serif;" /><span style="font-family: verdana,arial,helvetica,sans-serif;">Steven</span><br style="font-family: verdana,arial,helvetica,sans-serif;" /><br style="font-family: verdana,arial,helvetica,sans-serif;" /><br />Reece Hart wrote ..
<blockquote type="cite">

Does anyone out there have experience with connecting to oracle within a postgresql server, or vice versa?<br />
<br />
For postgresql servers, I'm aware that there's a modified dblink for oracle (<a href="http://archives.postgresql.org/pgsql-odbc/2003-10/msg00054.php),">http://archives.postgresql.org/pgsql-odbc/2003-10/msg00054.php</a>) and I remember seeing a post regarding dblink for jdbc in progress (I think by Joe Conway).<br />
<br />
For oracle, there's HS-ODBC.<br />
<br />
I don't see many questions or user experience on the web or in groups for these topics, or announcements about new versions of dblink for oracle. Any comments from the sfpug folks? I'm surprised that this isn't a hotter topic.<br />
<br />
Thanks,<br />
Reece<br />
<br />
<table width="100%" cellspacing="0" cellpadding="0">
<tbody><tr>
<td>
-- <br />
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0<br />
<br />
<br />
</td>
</tr>
</tbody></table>
</blockquote><br />

--bound1109794465--