Postgres Pro
Downloads
Home   >   mailing lists

Thread: How to connect ORACLE database from Postgres function using plpgsql/pltclu?

How to connect ORACLE database from Postgres function using plpgsql/pltclu?

From
"Dinesh Pandey"
Date:
<div class="Section1"><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt;
font-family:Verdana">Is there any way to connect ORACLE database from Postgres function using
plpgsql/pltclu?</span></font><pclass="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt; 
font-family:Verdana"> </span></font><p><font face="Verdana" size="2"><span style="font-size:10.0pt">Thanks<br /> Dinesh
Pandey</span></font><fontface="Times New Roman"><span style="font-family: 
"Times New Roman""><br /><br /><br /></span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><span
style="font-size:
12.0pt"> </span></font></div>

Re: How to connect ORACLE database from Postgres function using plpgsql/pltclu?

From
Dawid Kuroczko
Date:
On 8/1/05, Dinesh Pandey <dpandey@secf.com> wrote:
> Is there any way to connect ORACLE database from Postgres function using
> plpgsql/pltclu?

With PLpgSQL I don't think its possible.  I don't know how about PLtclU (should
be possible), but I'm sure its doable from PLperlU (using DBI).  Don't expect it
to be easy to set up and fast performing though. ;)
  Regards,        Dawid

Re: How to connect ORACLE database from Postgres function

From
Sean Davis
Date:
<font face="Verdana"><span style="font-size:12.0px">On 8/1/05 6:35 AM, "Dawid Kuroczko" <qnex42@gmail.com>
wrote:<br/><br /></span></font><blockquote><font face="Verdana"><span style="font-size:12.0px">On 8/1/05, Dinesh Pandey
<dpandey@secf.com>wrote: <br /> > Is there any way to connect ORACLE database from Postgres function using <br
/>> plpgsql/pltclu? <br /><br /> With PLpgSQL I don't think its possible.  I don't know how about PLtclU (should <br
/>be possible), but I'm sure its doable from PLperlU (using DBI).  Don't expect it <br /> to be easy to set up and fast
performingthough. ;) <br /></span></font></blockquote><font face="Verdana"><span style="font-size:12.0px"><br /> Have a
lookat DBI-Link.  <br /><br /></span></font><font size="4"><font face="Lucida Grande"><span style="font-size:13.0px"><a
href="http://pgfoundry.org/projects/dbi-link">http://pgfoundry.org/projects/dbi-link</a><br/><br /> There is a
PostgreSQLtidbits column on DBI-Link here:<br /><br /><a
href="http://www.pervasive-postgres.com/postgresql/tidbits.asp">http://www.pervasive-postgres.com/postgresql/tidbits.asp</a><br
/><br/> Sean<br /></span></font></font>

Re: How to connect ORACLE database from Postgres functionusing plpgsql/pltclu?

From
"Dinesh Pandey"
Date:

Thanks Sean, It great help from you.

 

Thanks
Dinesh Pandey

From: Sean Davis [mailto:sdavis2@mail.nih.gov]
Sent: Monday, August 01, 2005 4:47 PM
To: dpandey@secf.com
Cc: PostgreSQL
Subject: Re: [SQL] How to connect ORACLE database from Postgres functionusing plpgsql/pltclu?

 

On 8/1/05 6:35 AM, "Dawid Kuroczko" <qnex42@gmail.com> wrote:

On 8/1/05, Dinesh Pandey <dpandey@secf.com> wrote:
> Is there any way to connect ORACLE database from Postgres function using
> plpgsql/pltclu?

With PLpgSQL I don't think its possible.  I don't know how about PLtclU (should
be possible), but I'm sure its doable from PLperlU (using DBI).  Don't expect it
to be easy to set up and fast performing though. ;)


Have a look at DBI-Link.  

http://pgfoundry.org/projects/dbi-link

There is a PostgreSQL tidbits column on DBI-Link here:

http://www.pervasive-postgres.com/postgresql/tidbits.asp

Sean