THE Procedure entry point OCIstmtgetNextresult could not be located in the dynamic link library oci.dll
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
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.