Re: Create connection with Oracle database from Postgres plpgsql function

From: Michael Glaesemann <grzm(at)myrealbox(dot)com>
To: <dpandey(at)secf(dot)com>
Cc: "'PostgreSQL'" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Create connection with Oracle database from Postgres plpgsql function
Date: 2005-07-05 10:02:11
Message-ID: C61C5740-FE75-4030-9C5F-E903B7A476A6@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


On Jul 5, 2005, at 6:40 PM, Dinesh Pandey wrote:

> How can we create connection with Oracle database from Postgres
> plpgsql function and execute some oracle stored procedure?

I don't think it's possible with plpgsql. Try DBI-link.
<http://pgfoundry.org/projects/dbi-link/>

Michael Glaesemann
grzm myrealbox com

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Zac 2005-07-05 11:47:24 Re: Help on Procedure running external function
Previous Message Dinesh Pandey 2005-07-05 09:40:41 Create connection with Oracle database from Postgres plpgsql function