THE Procedure entry point OCIstmtgetNextresult could not be located in the dynamic link library oci.dll

Question

I just installed xampp v3.2.2 on my pc. I want to create connection string to oracle using php. when i start Apache on xampp, always show popup window "OCI.DLL IS MISSING FROM your computer". I've been download oci.dll from http://www.dll-found.com/download/o/oci.dll and place it inside C/windows/SysWOW64

but, when i start apache on xampp again, show popup window "THE Procedure entry point OCIstmtgetNextresult could not be located in the dynamic link library oci.dll" like this screenshot

what should i do? thanks

Answer 1

You need to download the whole of the Oracle Instant client that matches your OS and its bitness, e.g. 12.1.0.2 for 64 bit for example, from the Oracle website (you may need to create a free account).

Uncompress the contents in the folder of your choice. Add the path to this folder to your PATH environment variable.

Copy all the files within the main directory to your Apache/bin folder, the one that contains httpd.exe Note that a subset of these files may be copied, but I can't remember which exactly. You may work by elimination eventually, once you have the system to work.

Configure php.ini (the one inside Apache) to activate this module:

extension=php_oci8_12c.dll  ; Use with Oracle Database 12c Instant Client

Restart Apache. It should work.

A similar job may be done for php in cli mode. In this case, copy the files from the Oracle Instant Client into the php folder, the one that contains php.exe, not the ext/ folder. Similarly, edit php.ini for cli. Verify that module oci8 gets loaded by issuing a:

php -m

command from a console. Remember that your should reopen the console to load the latest PATH variable.

Answer 2

this is a problem with the x64 Edition of PHP 5.6.2x and Oracle Instant Client....i got the same error, i changed to x86