From: Sean Davis <sdavis2@mail.nih.gov>
To: dpandey@secf.com
Cc: PostgreSQL <pgsql-sql@postgresql.org>
Subject: Re: How to connect ORACLE database from Postgres function
Date: Mon, 01 Aug 2005 07:16:44 -0400
Message-ID: <BF137CDC.ACFE%sdavis2@mail.nih.gov> (raw)
In-Reply-To: <758d5e7f050801033529c7179c@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sdavis2@mail.nih.gov, dpandey@secf.com
Subject: Re: How to connect ORACLE database from Postgres function
In-Reply-To: <BF137CDC.ACFE%sdavis2@mail.nih.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox