Postgres Pro
Downloads
Home   >   mailing lists

Re: Create connection with Oracle database from Postgres plpgsql function - Mailing list pgsql-sql

From Michael Glaesemann
Subject Re: Create connection with Oracle database from Postgres plpgsql function
Date
Msg-id C61C5740-FE75-4030-9C5F-E903B7A476A6@myrealbox.com
Whole thread Raw
In response to Create connection with Oracle database from Postgres plpgsql function  ("Dinesh Pandey" <dpandey@secf.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "Dinesh Pandey"
Date:
Subject: Create connection with Oracle database from Postgres plpgsql function
Next
From: Zac
Date:
Subject: Re: Help on Procedure running external function