X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AE7C752B3D for ; Mon, 1 Aug 2005 08:16:59 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 77448-06 for ; Mon, 1 Aug 2005 11:16:43 +0000 (GMT) Received: from mx5.net.nih.gov (mailfwd.nih.gov [165.112.130.36]) by svr1.postgresql.org (Postfix) with ESMTP id 5D58252C49 for ; Mon, 1 Aug 2005 08:16:42 -0300 (ADT) Received: from mx5.net.nih.gov (localhost [127.0.0.1]) by mx5.net.nih.gov (8.12.10/8.11.6) with ESMTP id j71BGiQ5028598 for ; Mon, 1 Aug 2005 07:16:45 -0400 Received: from [128.231.145.14] (holmes.nhgri.nih.gov [128.231.145.14]) by mx5.net.nih.gov (8.12.10/8.11.6) with ESMTP id j71BGiIJ028594; Mon, 1 Aug 2005 07:16:44 -0400 User-Agent: Microsoft-Entourage/10.1.4.030702.0 Date: Mon, 01 Aug 2005 07:16:44 -0400 Subject: Re: How to connect ORACLE database from Postgres function From: Sean Davis To: Cc: PostgreSQL Message-ID: In-Reply-To: <758d5e7f050801033529c7179c@mail.gmail.com> Mime-version: 1.0 Content-type: multipart/alternative; boundary="B_3205725404_25018242" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.165 tagged_above=0 required=5 tests=AWL, HTML_40_50, HTML_FONT_BIG, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200508/4 X-Sequence-Number: 22232 > This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --B_3205725404_25018242 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit On 8/1/05 6:35 AM, "Dawid Kuroczko" wrote: > On 8/1/05, Dinesh Pandey 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 --B_3205725404_25018242 Content-type: text/html; charset="US-ASCII" Content-transfer-encoding: quoted-printable Re: [SQL] How to connect ORACLE database from Postgres function usin= g plpgsql/pltclu? On 8/1/05 6:35 AM, &quo= t;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 usi= ng
> plpgsql/pltclu?

With PLpgSQL I don't think its possible.  I don't know how about PLtcl= U (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://pgfoundr= y.org/projects/dbi-link

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

http://w= ww.pervasive-postgres.com/postgresql/tidbits.asp

Sean
 --B_3205725404_25018242--