Re: Calling oracle function from PostgreSQL

From: Kashif Zeeshan <kashi(dot)zeeshan(at)gmail(dot)com>
To: Muhammad Ikram <mmikram(at)gmail(dot)com>
Cc: Shweta Rahate <rahateshweta20(at)gmail(dot)com>, pgsql-novice(at)lists(dot)postgresql(dot)org
Subject: Re: Calling oracle function from PostgreSQL
Date: 2024-08-30 16:48:27
Message-ID: CAAPsdhdh7ogmy3uq_fyo4xOODo6wt4DJeti3Cji6+5bKYV9hTQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Fri, Aug 30, 2024 at 12:18 PM Muhammad Ikram <mmikram(at)gmail(dot)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(at)gmail(dot)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
>
>

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message TIM CHILD 2024-08-30 23:12:10 Re: Calling oracle function from PostgreSQL
Previous Message Greg Sabino Mullane 2024-08-30 15:54:00 Re: Calling oracle function from PostgreSQL