Horton

Re: Calling oracle function from PostgreSQL

Kashif Zeeshan <kashi.zeeshan@gmail.com>

View thread View on postgr.es
From: Kashif Zeeshan <kashi.zeeshan@gmail.com>
To: Muhammad Ikram <mmikram@gmail.com>
Cc: Shweta Rahate <rahateshweta20@gmail.com>, pgsql-novice@lists.postgresql.org
Date: 2024-08-30T16:48:27Z
Lists: pgsql-novice 
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
>
>