From dpandey@secf.com Mon Aug 1 11:29:36 2005 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 EB2E452C5F for ; Mon, 1 Aug 2005 08:29:36 -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 76792-08 for ; Mon, 1 Aug 2005 11:29:28 +0000 (GMT) Received: from secf.com (209-128-104-244.BAYAREA.NET [209.128.104.244]) by svr1.postgresql.org (Postfix) with ESMTP id 819CD52C47 for ; Mon, 1 Aug 2005 08:29:25 -0300 (ADT) Received: from dinesh by secf.com (MDaemon.PRO.v8.0.2.R) with ESMTP id md50001366753.msg for ; Mon, 01 Aug 2005 04:31:04 -0700 Reply-To: From: "Dinesh Pandey" To: "'Sean Davis'" Cc: "'PostgreSQL'" Subject: Re: How to connect ORACLE database from Postgres functionusing plpgsql/pltclu? Date: Sun, 1 May 2005 16:57:20 +0530 Organization: Second Foundation India P Ltd. MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00CF_01C54E6E.D8DB7FC0" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 In-Reply-To: X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Thread-Index: AcWWir/zWw3GdifhQnWRMTF+t7RSJRISiJtg X-Authenticated-Sender: dpandey@secf.com X-Spam-Processed: mail.secf.com, Mon, 01 Aug 2005 04:31:04 -0700 (not processed: message from valid local sender) X-MDRemoteIP: 220.227.32.11 X-Return-Path: dpandey@secf.com X-MDaemon-Deliver-To: pgsql-sql@postgresql.org X-MDAV-Processed: mail.secf.com, Mon, 01 Aug 2005 04:31:05 -0700 Message-Id: <20050801112925.819CD52C47@svr1.postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.849 tagged_above=0 required=5 tests=AWL, DATE_IN_PAST_96_XX, FORGED_RCVD_HELO, HTML_MESSAGE, MSGID_FROM_MTA_ID X-Spam-Level: * X-Archive-Number: 200508/5 X-Sequence-Number: 22233 This is a multi-part message in MIME format. ------=_NextPart_000_00CF_01C54E6E.D8DB7FC0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Thanks Sean, It great help from you. Thanks Dinesh Pandey _____ From: Sean Davis [mailto:sdavis2@mail.nih.gov] Sent: Monday, August 01, 2005 4:47 PM To: dpandey@secf.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" wrote: On 8/1/05, Dinesh Pandey 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 ------=_NextPart_000_00CF_01C54E6E.D8DB7FC0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Re: [SQL] How to connect ORACLE database from Postgres function = using plpgsql/pltclu?

Thanks Sean, It great help from = you.

 

Thanks
Dinesh Pandey

From: Sean Davis [mailto:sdavis2@mail.nih.gov] =
Sent: Monday, August 01, = 2005 4:47 PM
To: dpandey@secf.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@gmail.com> wrote:

On 8/1/05, Dinesh Pandey <dpandey@secf.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/proj= ects/dbi-link

There is a PostgreSQL tidbits column on DBI-Link here:

http://= www.pervasive-postgres.com/postgresql/tidbits.asp

Sean

------=_NextPart_000_00CF_01C54E6E.D8DB7FC0-- From dpandey@secf.com Mon Aug 1 05:34:05 2005 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 DE15352B12 for ; Mon, 1 Aug 2005 02:34:05 -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 14106-04 for ; Mon, 1 Aug 2005 05:34:00 +0000 (GMT) Received: from secf.com (209-128-104-244.BAYAREA.NET [209.128.104.244]) by svr1.postgresql.org (Postfix) with ESMTP id 2CEE3529FA for ; Mon, 1 Aug 2005 02:33:56 -0300 (ADT) Received: from dinesh by secf.com (MDaemon.PRO.v8.0.2.R) with ESMTP id md50001365260.msg for ; Sun, 31 Jul 2005 22:34:53 -0700 Reply-To: From: "Dinesh Pandey" To: "'PostgreSQL'" Subject: How to connect ORACLE database from Postgres function using plpgsql/pltclu? Date: Mon, 1 Aug 2005 11:01:13 +0530 Organization: Second Foundation India P Ltd. MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00AB_01C59688.56E9D1D0" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Thread-Index: AcWWWjsDZ5+OLj3YR/W+DM+LVwD+tA== X-Authenticated-Sender: dpandey@secf.com X-Spam-Processed: mail.secf.com, Sun, 31 Jul 2005 22:34:53 -0700 (not processed: message from valid local sender) X-MDRemoteIP: 220.227.32.11 X-Return-Path: dpandey@secf.com X-MDaemon-Deliver-To: pgsql-sql@postgresql.org X-MDAV-Processed: mail.secf.com, Sun, 31 Jul 2005 22:34:55 -0700 Message-Id: <20050801053356.2CEE3529FA@svr1.postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.401 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, HTML_90_100, HTML_MESSAGE, MSGID_FROM_MTA_ID X-Spam-Level: * X-Archive-Number: 200508/1 X-Sequence-Number: 22229 This is a multi-part message in MIME format. ------=_NextPart_000_00AB_01C59688.56E9D1D0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Is there any way to connect ORACLE database from Postgres function using plpgsql/pltclu? Thanks Dinesh Pandey ------=_NextPart_000_00AB_01C59688.56E9D1D0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Is there any way to connect ORACLE database from = Postgres function using plpgsql/pltclu?

 

Thanks
Dinesh Pandey


 

------=_NextPart_000_00AB_01C59688.56E9D1D0-- From qnex42@gmail.com Mon Aug 1 10:35:26 2005 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 5BBF752C0B for ; Mon, 1 Aug 2005 07:35:26 -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 67795-09 for ; Mon, 1 Aug 2005 10:35:14 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.205]) by svr1.postgresql.org (Postfix) with ESMTP id DABC652A76 for ; Mon, 1 Aug 2005 07:35:12 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id 8so757762nzo for ; Mon, 01 Aug 2005 03:35:15 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=WNqkTXZxuZ/SNaoUFGB8chnfEchMjYY7T8uiURj91pZKY1ANQNdmo4AcvhvaJNdGECnjnwvNwmVjIdxv7Hj3wTYEYM5NPTj9HVQQmpJ8vC18jLYpBDbOqB9p/VwEWG7F86MlvKoQB4YjU96M78BulHj5L0+OvKl0FFtQbpdy88I= Received: by 10.36.25.4 with SMTP id 4mr5393211nzy; Mon, 01 Aug 2005 03:35:15 -0700 (PDT) Received: by 10.36.22.20 with HTTP; Mon, 1 Aug 2005 03:35:15 -0700 (PDT) Message-ID: <758d5e7f050801033529c7179c@mail.gmail.com> Date: Mon, 1 Aug 2005 12:35:15 +0200 From: Dawid Kuroczko Reply-To: Dawid Kuroczko To: dpandey@secf.com Subject: Re: How to connect ORACLE database from Postgres function using plpgsql/pltclu? Cc: PostgreSQL In-Reply-To: <20050801053356.2CEE3529FA@svr1.postgresql.org> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <20050801053356.2CEE3529FA@svr1.postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.616 tagged_above=0 required=5 tests=AWL, FROM_ENDS_IN_NUMS, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200508/3 X-Sequence-Number: 22231 On 8/1/05, Dinesh Pandey wrote: > Is there any way to connect ORACLE database from Postgres function using > plpgsql/pltclu?=20 With PLpgSQL I don't think its possible. I don't know how about PLtclU (sh= ould be possible), but I'm sure its doable from PLperlU (using DBI). Don't expe= ct it to be easy to set up and fast performing though. ;) Regards, Dawid From sdavis2@mail.nih.gov Mon Aug 1 11:16:59 2005 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 AE7C752B3D for ; Mon, 1 Aug 2005 08:16:59 -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 77448-06 for ; Mon, 1 Aug 2005 11:16:43 +0000 (GMT) Received: from mx5.net.nih.gov (mailfwd.nih.gov [165.112.130.36]) by svr1.postgresql.org (Postfix) with ESMTP id 5D58252C49 for ; Mon, 1 Aug 2005 08:16:42 -0300 (ADT) Received: from mx5.net.nih.gov (localhost [127.0.0.1]) by mx5.net.nih.gov (8.12.10/8.11.6) with ESMTP id j71BGiQ5028598 for ; Mon, 1 Aug 2005 07:16:45 -0400 Received: from [128.231.145.14] (holmes.nhgri.nih.gov [128.231.145.14]) by mx5.net.nih.gov (8.12.10/8.11.6) with ESMTP id j71BGiIJ028594; Mon, 1 Aug 2005 07:16:44 -0400 User-Agent: Microsoft-Entourage/10.1.4.030702.0 Date: Mon, 01 Aug 2005 07:16:44 -0400 Subject: Re: How to connect ORACLE database from Postgres function From: Sean Davis To: Cc: PostgreSQL Message-ID: In-Reply-To: <758d5e7f050801033529c7179c@mail.gmail.com> Mime-version: 1.0 Content-type: multipart/alternative; boundary="B_3205725404_25018242" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.165 tagged_above=0 required=5 tests=AWL, HTML_40_50, HTML_FONT_BIG, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200508/4 X-Sequence-Number: 22232 > This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --B_3205725404_25018242 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit On 8/1/05 6:35 AM, "Dawid Kuroczko" wrote: > On 8/1/05, Dinesh Pandey 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 --B_3205725404_25018242 Content-type: text/html; charset="US-ASCII" Content-transfer-encoding: quoted-printable Re: [SQL] How to connect ORACLE database from Postgres function usin= g plpgsql/pltclu? On 8/1/05 6:35 AM, &quo= t;Dawid Kuroczko" <qnex42@gmail.com> wrote:

On 8/1/05, Dinesh Pandey <dpandey@secf.com> wrote:
> Is there any way to connect ORACLE database from Postgres function usi= ng
> plpgsql/pltclu?

With PLpgSQL I don't think its possible.  I don't know how about PLtcl= U (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://pgfoundr= y.org/projects/dbi-link

There is a PostgreSQL tidbits column on DBI-Link here:

http://w= ww.pervasive-postgres.com/postgresql/tidbits.asp

Sean
 --B_3205725404_25018242--