MIME-Version: 1.0
From: Santhosh S <sansel25041991@gmail.com>
Date: Wed, 2 Jul 2025 23:58:33 +0530
Message-ID: 
 <CAJgCXzONczgOARwKW-BVc_kG3JLrUa_B4nhymrAhVQB1vpCe0g@mail.gmail.com>
Subject: Foreign Data Wrapper from Oracle to Postgres 16
To: pgsql-general@postgresql.org, pgsql-novice@postgresql.org
Content-Type: multipart/alternative; boundary="0000000000005f5f220638f66e66"
Archived-At: 
 <https://www.postgresql.org/message-id/CAJgCXzONczgOARwKW-BVc_kG3JLrUa_B4nhymrAhVQB1vpCe0g%40mail.gmail.com>
Precedence: bulk

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

Hi team,

I am working on a project along with my peers on developing an Foreign Data
Wrapper to transfer data from Oracle to Postgres 16. We followed the below
steps in order:

1. Developed the Foreign Data Wrapper (64-bit) using Microsoft Visual
Studio to transfer from Oracle to Postgres 16
2. Installed Oracle Instant Client 64-bit versionand InstantClient Path has
been set in the environment variables
3. Have Postgres 16 64-bit version installed
4. Placed all the files from each folder of the downloaded ORACLE_FDW
package should be copied into the respective folders of PostgreSQL
Installation directory
5. =E2=80=9Coci.dll=E2=80=9D from the Oracle Instant Client Installation di=
rectory to
PostgreSQL Installation directory
6. Visual C++ redistributable is installed

After the above steps when we try to execute the below statement in
Postgres 16

CREATE EXTENSION IF NOT EXISTS oracle_fdw
SCHEMA public
VERSION "1.2"

we get the error "SQL Error [58P01]: ERROR: could not load library
"C:/Program Files/PostgreSQL/16/lib/oracle_fdw.dll": The specified module
could not be found.
Error position"

But we are able to execute the above command successfully in Postgres 13
and successfully transfer data from Oracle to Postgres 13.

Any help or direction would be greatly helpful.

Regards
Santhosh S

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

<div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div di=
r=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr">Hi team,<div><br></div><div>I a=
m working on a project along with my peers on developing an=C2=A0Foreign Da=
ta Wrapper to transfer data from Oracle to Postgres 16. We followed the bel=
ow steps in order:</div><div><br></div><div>1. Developed the Foreign Data W=
rapper (64-bit) using Microsoft Visual Studio to transfer from Oracle to Po=
stgres 16</div><div>2. Installed Oracle Instant Client 64-bit versionand In=
stantClient Path has been set in the environment variables</div><div>3. Hav=
e Postgres 16 64-bit version installed</div><div>4. Placed all the files fr=
om each folder of the downloaded ORACLE_FDW package should be copied into t=
he respective folders of PostgreSQL Installation directory</div><div>5.=C2=
=A0=E2=80=9Coci.dll=E2=80=9D from the Oracle Instant Client Installation di=
rectory to PostgreSQL Installation directory</div><div>6. Visual C++ redist=
ributable is installed</div><div><br></div><div>After the above steps when =
we try to execute the below statement in Postgres 16</div><div><br></div>CR=
EATE EXTENSION IF NOT EXISTS oracle_fdw<br>SCHEMA public<br>VERSION &quot;1=
.2&quot;</div><div dir=3D"ltr"><br></div><div>we get the error &quot;SQL Er=
ror [58P01]: ERROR: could not load library &quot;C:/Program Files/PostgreSQ=
L/16/lib/oracle_fdw.dll&quot;: The specified module could not be found.</di=
v><div>Error position&quot;=C2=A0</div><div><br></div><div>But we are able =
to execute the above command successfully in Postgres 13 and successfully t=
ransfer data from Oracle to Postgres 13.</div><div><br></div><div>Any help =
or direction would be greatly helpful.</div><div><br></div><div>Regards</di=
v><div>Santhosh S</div></div></div></div></div></div></div>

--0000000000005f5f220638f66e66--