X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 325655286C for ; Tue, 5 Jul 2005 07:02:21 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 49196-06 for ; Tue, 5 Jul 2005 10:02:16 +0000 (GMT) Received: from smtp-send.myrealbox.com (smtp-send.myrealbox.com [192.108.102.143]) by svr1.postgresql.org (Postfix) with ESMTP id 7FD165280B for ; Tue, 5 Jul 2005 07:02:12 -0300 (ADT) Received: from [172.16.1.204] glaesema [61.197.227.146] by smtp-send.myrealbox.com with NetMail SMTP Agent $Revision: 1.5 $ on Linux via secured & encrypted transport (TLS); Tue, 05 Jul 2005 04:02:14 -0600 In-Reply-To: <20050705094703.4EFF85280B@svr1.postgresql.org> References: <20050705094703.4EFF85280B@svr1.postgresql.org> Mime-Version: 1.0 (Apple Message framework v730) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Cc: "'PostgreSQL'" Content-Transfer-Encoding: 7bit From: Michael Glaesemann Subject: Re: Create connection with Oracle database from Postgres plpgsql function Date: Tue, 5 Jul 2005 19:02:11 +0900 To: X-Mailer: Apple Mail (2.730) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200507/24 X-Sequence-Number: 22002 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. Michael Glaesemann grzm myrealbox com