MIME-Version: 1.0
References: 
 <CAPuJPo5GgMXnwtdOERwHgrEgthqyX+iO0GL6Mv7qCw7uOz6T8g@mail.gmail.com>
 <CAGeimVq1TJTeeRWX6nqUOuhr9vvMDkDC=X+NY7dYiPFWDoX+cg@mail.gmail.com>
In-Reply-To: 
 <CAGeimVq1TJTeeRWX6nqUOuhr9vvMDkDC=X+NY7dYiPFWDoX+cg@mail.gmail.com>
From: Kashif Zeeshan <kashi.zeeshan@gmail.com>
Date: Fri, 30 Aug 2024 21:48:27 +0500
Message-ID: 
 <CAAPsdhdh7ogmy3uq_fyo4xOODo6wt4DJeti3Cji6+5bKYV9hTQ@mail.gmail.com>
Subject: Re: Calling oracle function from PostgreSQL
To: Muhammad Ikram <mmikram@gmail.com>
Cc: Shweta Rahate <rahateshweta20@gmail.com>,
 pgsql-novice@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000f641690620e95c87"
Archived-At: 
 <https://www.postgresql.org/message-id/CAAPsdhdh7ogmy3uq_fyo4xOODo6wt4DJeti3Cji6%2B5bKYV9hTQ%40mail.gmail.com>
Precedence: bulk

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

On Fri, Aug 30, 2024 at 12:18=E2=80=AFPM 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=E2=80=AFPM Shweta Rahate <rahateshweta20@gm=
ail.com>
> wrote:
>
>> Hi All,
>>
>> In my application there is a requirement to call the oracle function fro=
m
>> 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
>
>

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

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote">=
<div dir=3D"ltr" class=3D"gmail_attr">On Fri, Aug 30, 2024 at 12:18=E2=80=
=AFPM Muhammad Ikram &lt;<a href=3D"mailto:mmikram@gmail.com">mmikram@gmail=
.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"mar=
gin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1=
ex"><div dir=3D"ltr">Hi<div><br></div><div>Please explore oracle_fdw.=C2=A0=
</div></div></blockquote><div>Oracle FDW does not support calling Oracle Fu=
nctions in Postgres, their main purpose is accessing table data.=C2=A0</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"ltr"><div><b=
r></div><div>Regards,</div><div>Muhammad Ikram</div><div><br></div></div><b=
r><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Fri, =
Aug 30, 2024 at 12:09=E2=80=AFPM Shweta Rahate &lt;<a href=3D"mailto:rahate=
shweta20@gmail.com" target=3D"_blank">rahateshweta20@gmail.com</a>&gt; wrot=
e:<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"a=
uto">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 PostgreSQL db.</di=
v><div dir=3D"auto"><br></div><div dir=3D"auto">The oracle function should =
take the input from Postgres db and returns the output.</div><div dir=3D"au=
to">Please suggest a way to achieve=C2=A0this.=C2=A0</div><div 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><br clear=3D"all"><div><br></div><span class=3D"gmail_si=
gnature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><d=
iv dir=3D"ltr"><div>Muhammad Ikram<br><br></div></div></div>
</blockquote></div></div>

--000000000000f641690620e95c87--