Re: How to connect ORACLE database from Postgres function

From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
To: <dpandey(at)secf(dot)com>
Cc: PostgreSQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: How to connect ORACLE database from Postgres function
Date: 2005-08-01 11:16:44
Message-ID: BF137CDC.ACFE%sdavis2@mail.nih.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 8/1/05 6:35 AM, "Dawid Kuroczko" <qnex42(at)gmail(dot)com> wrote:

> On 8/1/05, Dinesh Pandey <dpandey(at)secf(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Chris Mungall 2005-08-01 21:43:52 Calling SQL functions that return sets
Previous Message Dawid Kuroczko 2005-08-01 10:35:15 Re: How to connect ORACLE database from Postgres function using plpgsql/pltclu?