php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Doc Bug #78074 PDO_OCI not working
Submitted: 2019-05-27 10:05 UTC Modified: 2019-06-01 08:42 UTC
From: berger at gmx dot de Assigned: cmb (profile)
Status: Closed Package: PDO OCI
PHP Version: 7.3.6RC1 OS: Windows 10
Private report: No CVE-ID: None
 [2019-05-27 10:05 UTC] berger at gmx dot de
Description:
------------
Cannot get the oracle driver working with php (7.1 & 7.3.7-dev).

DSN-String is: oci://hostname:port/dbname

Error message is: Uncaught PDOException: could not find driver in ...

Line "extension=php_pdo_oci.dll" is activated in php.ini

phpinfo() shows:

    PDO drivers	 mysql, pgsql, sqlsrv







Test script:
---------------
Uncomment line "extension=php_pdo_oci.dll" in php.ini

Then run phpinfo() and go to "PDO"-Section.

Expected result:
----------------
PDO OCI (Oracle) Driver active and running

Actual result:
--------------
PDO OCI (Oracle) Driver not loaded and running

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2019-05-27 10:29 UTC] cmb@php.net
-Status: Open +Status: Feedback -Assigned To: +Assigned To: cmb
 [2019-05-27 10:29 UTC] cmb@php.net
Do you have the appropriate OCI.DLL in your path?
 [2019-05-27 10:55 UTC] berger at gmx dot de
-Status: Feedback +Status: Assigned
 [2019-05-27 10:55 UTC] berger at gmx dot de
I don't know what exactly you mean with that question?

There is a "php_pdo_oci.dll" in the "ext"-subdirectory. I have not installed third party drivers. This was not necessary for the other DB-Systems (mysql & postgre) either. For Microsoft SQL Server I had to download the driver manually from microsoft and after putting the dll into the ext-path and registering it within the php.ini everything worked fine.

Just the (prepackaged) oracle driver doesn't want to work.
 [2019-05-27 11:10 UTC] cmb@php.net
For oci and pdo_oci, you need to install the Oracle instant
client[1].  The documentation needs to be improved in this regard.

[1] <https://www.oracle.com/technetwork/topics/winsoft-085727.html>
 or <https://www.oracle.com/technetwork/topics/winx64soft-089540.html>
 [2019-05-27 11:11 UTC] cmb@php.net
-Type: Bug +Type: Documentation Problem
 [2019-06-01 08:41 UTC] cmb@php.net
Automatic comment from SVN on behalf of cmb
Revision: http://svn.php.net/viewvc/?view=revision&amp;revision=347520
Log: Fix #78074: PDO_OCI not working
 [2019-06-01 08:42 UTC] cmb@php.net
-Status: Assigned +Status: Closed
 [2019-06-01 08:42 UTC] cmb@php.net
This bug has been fixed in the documentation's XML sources. Since the
online and downloadable versions of the documentation need some time
to get updated, we would like to ask you to be a bit patient.

Thank you for the report, and for helping us make our documentation better.
 [2019-06-01 08:45 UTC] salathe@php.net
Automatic comment on behalf of cmb
Revision: http://git.php.net/?p=doc/en.git;a=commit;h=3ebba882578cd1d736c389e35c9c466b64c32558
Log: Fix #78074: PDO_OCI not working
 [2020-02-07 06:05 UTC] phpdocbot@php.net
Automatic comment on behalf of cmb
Revision: http://git.php.net/?p=doc/en.git;a=commit;h=537e6eeb269cf03277df4c947fccf8e2a8d944bf
Log: Fix #78074: PDO_OCI not working
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Fri Mar 29 10:01:28 2024 UTC