'SAS Enterprise 8.3 oci.dll not found error

I am using Windows 10 machine and have Oracle 12.2.0 installed. When I use ODBC, I can connect successfully to Oracle data-warehouses. But when I try to make an Oracle connection within SAS I get the below error

615        LIBNAME INFO ORACLE  PATH='XXXXXXXX' SCHEMA='XX' USER='XXXXXX' PASSWORD=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
615      ! ; run;
ERROR: Unable to load oracle client (oci.dll)
ERROR: Error in the LIBNAME statement.

My path variable has the following in it

C:\app32\client\product\12.2.0\client_1\bin;C:\app\client\product\12.2.0\client_1\bin;

I created a system "ORACLE_HOME" variable which its value is

C:\app\client\product\12.2.0\client_1\bin

Has anyone come across this error and resolved it?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source