MIME-Version: 1.0
References: 
 <CAPuJPo5GgMXnwtdOERwHgrEgthqyX+iO0GL6Mv7qCw7uOz6T8g@mail.gmail.com>
In-Reply-To: 
 <CAPuJPo5GgMXnwtdOERwHgrEgthqyX+iO0GL6Mv7qCw7uOz6T8g@mail.gmail.com>
From: Kashif Zeeshan <kashi.zeeshan@gmail.com>
Date: Fri, 30 Aug 2024 12:18:01 +0500
Message-ID: 
 <CAAPsdhdHnoPPW+pAPRO_eDd3h5Zyq-oL5evT7UjR=_UaZGjjnQ@mail.gmail.com>
Subject: Re: Calling oracle function from PostgreSQL
To: Shweta Rahate <rahateshweta20@gmail.com>
Cc: pgsql-novice@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000e061cb0620e16448"
Archived-At: 
 <https://www.postgresql.org/message-id/CAAPsdhdHnoPPW%2BpAPRO_eDd3h5Zyq-oL5evT7UjR%3D_UaZGjjnQ%40mail.gmail.com>
Precedence: bulk

--000000000000e061cb0620e16448
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi Shweta

There is no such feature either by Oracle  fdw or db links to call Oracle
functions in Postgres as per my knowledge.

Thanks & Regards
Kashif Zeeshan

On Fri, Aug 30, 2024 at 12:09=E2=80=AFPM Shweta Rahate <rahateshweta20@gmai=
l.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 th=
e
> output.
> Please suggest a way to achieve this.
>
>
>
> Regards,
> Shweta
>

--000000000000e061cb0620e16448
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi=C2=A0Shweta<div><br></div><div>There is no such feature=
 either by Oracle=C2=A0 fdw or db links to call Oracle functions in Postgre=
s as per my knowledge.</div><div><br></div><div>Thanks &amp; Regards</div><=
div>Kashif Zeeshan</div></div><br><div class=3D"gmail_quote"><div dir=3D"lt=
r" class=3D"gmail_attr">On Fri, Aug 30, 2024 at 12:09=E2=80=AFPM Shweta Rah=
ate &lt;<a href=3D"mailto:rahateshweta20@gmail.com">rahateshweta20@gmail.co=
m</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin=
:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"=
><div dir=3D"auto">Hi All,<div dir=3D"auto"><br></div><div dir=3D"auto">In =
my application there is a requirement to call the oracle function from Post=
greSQL db.</div><div dir=3D"auto"><br></div><div dir=3D"auto">The oracle fu=
nction should take the input from Postgres db and returns the output.</div>=
<div dir=3D"auto">Please suggest a way to achieve=C2=A0this.=C2=A0</div><di=
v dir=3D"auto"><br></div><div dir=3D"auto"><br></div><div dir=3D"auto"><br>=
</div><div dir=3D"auto">Regards,</div><div dir=3D"auto">Shweta</div></div>
</blockquote></div>

--000000000000e061cb0620e16448--