Thread: Postgres stored proc that extracts data from Oracle

Hello All,

I am a beginning PL/pgSQL and PL/SQL developer and I
have a question. I need to create a procedure in
postgres that  would compare data between a table in
Postgres and a table in Oracle. Let's put it like
this, I have a list of projects in a table in PG and
the properties of those projects can be found in a
table in an Oracle DB. I need to create a procedure
that gets a list of all projects with a certain
status. A list of project ID's must be fetched from
postgres and the status of each project ID is in
Oracle.

Do you guys have thoughts on how to implement this? I
am not expecting an easy solution but I wish to get
started asap. Any advice would be appreciated.

Thanks in advance,

James



__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/

On Thu, Mar 10, 2005 at 17:12:46 -0800,
  James <jamesfuerte@yahoo.com> wrote:
>
> Do you guys have thoughts on how to implement this? I
> am not expecting an easy solution but I wish to get
> started asap. Any advice would be appreciated.

My usual solution is to use a perl script which talks to both databases.

The dblink module in postgres might also be useful to you.