MIME-Version: 1.0
From: Yongye Serkfem <yserkfem@gmail.com>
Date: Tue, 22 Apr 2025 07:28:33 -0400
Message-ID: <CAAu_hGs2hGk8M4+1QO=6mK+nEHR0HHc49RciADRBAWmsqgFDpw@mail.gmail.com>
Subject: Oracle_fdw
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000009bf90a06335c49bf"
Archived-At: <https://www.postgresql.org/message-id/CAAu_hGs2hGk8M4%2B1QO%3D6mK%2BnEHR0HHc49RciADRBAWmsqgFDpw%40mail.gmail.com>
Precedence: bulk

--0000000000009bf90a06335c49bf
Content-Type: text/plain; charset="UTF-8"

Hello Team!
We are using Postgresql-15, ahd having issues importing foreign schema with
all its objects from an Oracle databse. Here is the error I am getting,
"error connecting to Oracle: OCIEnvCreate failed to create environment
handle: Detail: SQL state: HV00N
I have installed oracle instantclient 19_24
I would appreciate any help getting this resolved.

Regards
Yong Serk

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

<div dir=3D"ltr">Hello Team!<div>We are using Postgresql-15, ahd having iss=
ues importing foreign schema with all its objects from an Oracle databse.=
=C2=A0Here is the error I am getting, &quot;error connecting=C2=A0to Oracle=
: OCIEnvCreate failed to create environment handle: Detail: SQL state: HV00=
N<br></div><div>I have installed oracle instantclient=C2=A019_24</div><div>=
I would appreciate any help getting this resolved.=C2=A0</div><div><br></di=
v><div>Regards</div><div>Yong Serk</div></div>

--0000000000009bf90a06335c49bf--