Postgres Pro
Downloads
Home   >   mailing lists

Re: Calling oracle function from PostgreSQL - Mailing list pgsql-novice

From Kashif Zeeshan
Subject Re: Calling oracle function from PostgreSQL
Date
Msg-id CAAPsdhdh7ogmy3uq_fyo4xOODo6wt4DJeti3Cji6+5bKYV9hTQ@mail.gmail.com
Whole thread Raw
In response to Re: Calling oracle function from PostgreSQL  (Muhammad Ikram <mmikram@gmail.com>)
List pgsql-novice
Tree view


On Fri, Aug 30, 2024 at 12:18 PM Muhammad Ikram <mmikram@gmail.com> wrote:
Hi

Please explore oracle_fdw. 
Oracle FDW does not support calling Oracle Functions in Postgres, their main purpose is accessing table data. 

Regards,
Muhammad Ikram


On Fri, Aug 30, 2024 at 12:09 PM Shweta Rahate <rahateshweta20@gmail.com> wrote:
Hi All,

In my application there is a requirement to call the oracle function from PostgreSQL db.

The oracle function should take the input from Postgres db and returns the output.
Please suggest a way to achieve this. 



Regards,
Shweta


--
Muhammad Ikram

pgsql-novice by date:

Previous
From: Greg Sabino Mullane
Date:
Subject: Re: Calling oracle function from PostgreSQL
Next
From: TIM CHILD
Date:
Subject: Re: Calling oracle function from PostgreSQL