From: Dinesh Pandey <dpandey@secf.com>
To: 'Sean Davis' <sdavis2@mail.nih.gov>
Cc: 'PostgreSQL' <pgsql-sql@postgresql.org>
Subject: Re: How to connect ORACLE database from Postgres functionusing plpgsql/pltclu?
Date: Sun, 1 May 2005 16:57:20 +0530
Message-ID: <20050801112925.819CD52C47@svr1.postgresql.org> (raw)
In-Reply-To: <BF137CDC.ACFE%sdavis2@mail.nih.gov>
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
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: dpandey@secf.com, sdavis2@mail.nih.gov
Subject: Re: How to connect ORACLE database from Postgres functionusing plpgsql/pltclu?
In-Reply-To: <20050801112925.819CD52C47@svr1.postgresql.org>
* 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