Message-ID: <abe0a74b0cfb238ce5dc8db5fd16d48ce2953364.camel@cybertec.at>
Subject: Re: Foreign Data Wrapper from Oracle to Postgres 16
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Santhosh S <sansel25041991@gmail.com>, pgsql-general@postgresql.org,
	pgsql-novice@postgresql.org
Date: Thu, 03 Jul 2025 08:50:22 +0200
In-Reply-To: 
 <CAJgCXzONczgOARwKW-BVc_kG3JLrUa_B4nhymrAhVQB1vpCe0g@mail.gmail.com>
References: 
	<CAJgCXzONczgOARwKW-BVc_kG3JLrUa_B4nhymrAhVQB1vpCe0g@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.56.2 (3.56.2-1.fc42) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/abe0a74b0cfb238ce5dc8db5fd16d48ce2953364.camel%40cybertec.at>
Precedence: bulk

On Wed, 2025-07-02 at 23:58 +0530, Santhosh S wrote:
> I am working on a project along with my peers on developing an=C2=A0Forei=
gn Data Wrapper
> to transfer data from Oracle to Postgres 16. We followed the below steps =
in order:
>=20
> 1. Developed the Foreign Data Wrapper (64-bit) using Microsoft Visual Stu=
dio to transfer from Oracle to Postgres 16
> 2. Installed Oracle Instant Client 64-bit versionand InstantClient Path h=
as 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 pac=
kage should
>    be copied into the respective folders of PostgreSQL Installation direc=
tory
> 5.=C2=A0=E2=80=9Coci.dll=E2=80=9D from the Oracle Instant Client Installa=
tion directory to PostgreSQL Installation directory
> 6. Visual C++ redistributable is installed
>=20
> After the above steps when we try to execute the below statement in Postg=
res 16
>=20
> CREATE EXTENSION IF NOT EXISTS oracle_fdw
> SCHEMA public
> VERSION "1.2"
>=20
> we get the error "SQL Error [58P01]: ERROR: could not load library "C:/Pr=
ogram Files/PostgreSQL/16/lib/oracle_fdw.dll": The specified module could n=
ot be found.
> Error position"=C2=A0
>=20
> But we are able to execute the above command successfully in Postgres 13 =
and successfully transfer data from Oracle to Postgres 13.
>=20
> Any help or direction would be greatly helpful.

This is better tracked here: https://github.com/laurenz/oracle_fdw/issues/7=
54

By the way, I took a double take when I read your report.
For me "developing" a FDW means writing the code, whereas you are clearly
talking about what I would call "building", "compiling" or "instaling"
the FDW.  No problem, I just want to avoid confusion.

Yours,
Laurenz Albe