Thread: ORACLE_FDW

ORACLE_FDW

From
"Saravanan S"
Date:

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.

Re: ORACLE_FDW

From
Guillaume Lelarge
Date:

Hi

Le 23 juin 2015 5:51 PM, "Saravanan S" <saravanan.s@alshaya.com> a écrit :
>
> 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.
>

That's normal. You can only access tables and views through postgresql_fdw.

Re: ORACLE_FDW

From
Guillaume Lelarge
Date:

Le 23 juin 2015 11:45 PM, "Guillaume Lelarge" <guillaume@lelarge.info> a écrit :
>
> Hi
>
> Le 23 juin 2015 5:51 PM, "Saravanan S" <saravanan.s@alshaya.com> a écrit :
> >
> > 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.
> >
>
> That's normal. You can only access tables and views through postgresql_fdw.

Sorry, I meant ora_fdw.