pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Michael Glaesemann <grzm@myrealbox.com>
To: dpandey@secf.com
Cc: 'PostgreSQL' <pgsql-sql@postgresql.org>
Subject: Re: Create connection with Oracle database from Postgres plpgsql function
Date: Tue, 5 Jul 2005 19:02:11 +0900
Message-ID: <C61C5740-FE75-4030-9C5F-E903B7A476A6@myrealbox.com> (raw)
In-Reply-To: <20050705094703.4EFF85280B@svr1.postgresql.org>
References: <20050705094703.4EFF85280B@svr1.postgresql.org>


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





view thread (3+ messages)  latest in thread

Message-ID: <C61C5740-FE75-4030-9C5F-E903B7A476A6@myrealbox.com>
Permalink:  ../C61C5740-FE75-4030-9C5F-E903B7A476A6@myrealbox.com/
Also on:    postgresql.org/message-id/C61C5740-FE75-4030-9C5F-E903B7A476A6@myrealbox.com

 · 

reply

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: grzm@myrealbox.com, dpandey@secf.com
  Subject: Re: Create connection with Oracle database from Postgres plpgsql function
  In-Reply-To: <C61C5740-FE75-4030-9C5F-E903B7A476A6@myrealbox.com>

* 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