Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Z7QR7-00060N-8l for pgsql-admin@arkaria.postgresql.org; Tue, 23 Jun 2015 15:48:33 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1Z7QR5-0000XK-Kj for pgsql-admin@arkaria.postgresql.org; Tue, 23 Jun 2015 15:48:31 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1Z7K9l-0006xf-Ew for pgsql-admin@postgresql.org; Tue, 23 Jun 2015 09:06:13 +0000 Received: from mx08-00199a01.pphosted.com ([91.207.212.110] helo=m0077490.ppops.net) by makus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1Z7K9Z-0001a5-Cr for pgsql-admin@postgresql.org; Tue, 23 Jun 2015 09:06:10 +0000 Received: from pps.filterd (m0077490.ppops.net [127.0.0.1]) by m0077490.ppops.net (8.14.7/8.14.7) with SMTP id t5N95ult003667 for ; Tue, 23 Jun 2015 12:05:58 +0300 Received: from mta-pri-01.alshaya.com ([91.246.14.30]) by mx08-00199a01.pphosted.com with ESMTP id 1v54g8hpct-1 for ; Tue, 23 Jun 2015 12:05:58 +0300 Received: from localhost (localhost.localdomain [127.0.0.1]) by mta-pri-01.alshaya.com (Postfix) with ESMTP id 976235D22D5 for ; Tue, 23 Jun 2015 12:05:57 +0300 (AST) X-Virus-Scanned: amavisd-new at alshaya.com Received: from mta-pri-01.alshaya.com ([127.0.0.1]) by localhost (mta-pri-01.alshaya.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id jpGVzsNf5IYB for ; Tue, 23 Jun 2015 12:05:57 +0300 (AST) Received: from mtakuw03.alshaya.com (mtakuw03.alshaya.com [172.16.98.156]) by mta-pri-01.alshaya.com (Postfix) with ESMTP id 704595D22D1 for ; Tue, 23 Jun 2015 12:05:57 +0300 (AST) Received: from localhost (localhost [127.0.0.1]) by mtakuw03.alshaya.com (Postfix) with ESMTP id 6B5E08D3346 for ; Tue, 23 Jun 2015 12:05:57 +0300 (AST) X-Virus-Scanned: amavisd-new at mtakuw03.alshaya.com Received: from mtakuw03.alshaya.com ([127.0.0.1]) by localhost (mtakuw03.alshaya.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id Ru9LLIqYAcUg for ; Tue, 23 Jun 2015 12:05:57 +0300 (AST) Received: from INDLT00042 (unknown [10.29.17.149]) by mtakuw03.alshaya.com (Postfix) with ESMTPA id D6B358D3309 for ; Tue, 23 Jun 2015 12:05:56 +0300 (AST) From: "Saravanan S" To: Subject: ORACLE_FDW Date: Tue, 23 Jun 2015 14:35:50 +0530 Message-ID: <016801d0ad93$d054a3b0$70fdeb10$@alshaya.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0169_01D0ADC1.EA0DA300" X-Mailer: Microsoft Outlook 15.0 Thread-Index: AdCtkz0C7hJBkskOSPa4PF42rL+Gaw== Content-Language: en-in X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10432:5.14.151, 1.0.33, 0.0.0000 definitions=2015-06-23_03:2015-06-22,2015-06-23,1970-01-01 signatures=0 X-Proofpoint-Spam-Details: rule=outboundspam_notspam policy=outboundspam score=0 spamscore=0 suspectscore=1 phishscore=0 adultscore=0 bulkscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=7.0.1-1402240000 definitions=main-1506230148 X-Pg-Spam-Score: 0.8 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multipart message in MIME format. ------=_NextPart_000_0169_01D0ADC1.EA0DA300 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi All, I configured oracle_fdw in postgresql 9.3 on RHEL 6.5. Its working fine with the table,view & synonym. But I'm not able to access procedure & packages through foreign server. Kindly help me. Thanks in advance Saravanan.S ============================================================================================================================================ Alshaya Confidentiality Notice & Disclaimer This email and any attached or transmitted files may contain confidential and/or privileged information and are intended solely for the addressee(s) named. If you have received this information in error, please notify the sender by return email, do not redistribute this email message, delete it immediately and keep no copies of it. All opinions expressed in this email are solely those of the author and do not necessarily represent those of Alshaya. Neither this email nor any attached or transmitted files constitute a binding commitment on behalf of Alshaya. Any purported commitment or purchase order is subject to final approval in accordance with our internal procedures and subject to contract in accordance with the relevant laws. References to Alshaya include M.H. Alshaya Co. W.L.L. and all its affiliated companies. ------=_NextPart_000_0169_01D0ADC1.EA0DA300 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi All,<= o:p>

 

I configured oracle_fdw in postgresql 9.3 on RHEL 6.5. Its working fine w= ith the table,view & synonym.

But I= ’m not able to access procedure & packages through foreign server= . Kindly help me.

 

<= p class=3DMsoNormal> 

Thanks in adv= ance

 

Sa= ravanan.S

 

Alshaya Confidentiality Notice & Disclaimer
This email and any attached or transmitted files may contain confidential a= nd/or privileged information and are intended solely for the addressee(s) n= amed. If you have received this information in error, please notify the sen= der by return email, do not redistribute this email message, delete it imme= diately and keep no copies of it. All opinions expressed in this email are= solely those of the author and do not necessarily represent those of Alsha= ya. Neither this email nor any attached or transmitted files constitute a = binding commitment on behalf of Alshaya. Any purported commitment or purch= ase order is subject to final approval in accordance with our internal proc= edures and subject to contract in accordance with the relevant laws. Refer= ences to Alshaya include M.H. Alshaya Co. W.L.L. and all its affiliated com= panies.
------=_NextPart_000_0169_01D0ADC1.EA0DA300--