Re: How to connect ORACLE database from Postgres functionusing plpgsql/pltclu?

Thanks Sean, It great help from you.

Thanks
Dinesh Pandey

_____

From: Sean Davis [mailto:sdavis2(at)mail(dot)nih(dot)gov]
Sent: Monday, August 01, 2005 4:47 PM
To: dpandey(at)secf(dot)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(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