How to fix error "Uncaught Error: Call to undefined function oci_connect()" in wamp server?

Question

I have uncommented the following two lines in my php.ini:

extension=php_pdo_oci.dll
extension=php_oci8_12c.dll

Code:

public static function getAllNames(){
    $dbUser = "xxx";
    $dbPass = "xxxx";
    $dbConn = "(DESCRIPTION = (ADDRESS = (PROTOCOL=TCP)(HOST=xxxx)(PORT=xxxx))(CONNECT_DATA=(SID=xxxx)))";
    $conn = oci_connect($dbUser, $dbPass, $dbConn);
    $sql = oci_parse($conn,"Select FNAME, LNAME from PERSONA  WHERE STATUS = 'A' ORDER BY FNAME");
    return $sql;
    }

I'm not able to get rid of the error. I have seen a couple of questions similar to mine, but most of them were using apache server and couldn't really solve my problem. Any help would be appreciated. Thanks

refer to this https://stackoverflow.com/questions/22478387/call-to-undefined-function-oci-connect, maybe because you install Oracle Instant Client 64bit. try to install the 32bit version — GNassro, Aug 14 '20 at 18:00
Okay. Do i need to install the file in a specific directory? — AAM, Aug 14 '20 at 18:01
try this one https://stackoverflow.com/a/40080784/8010101 maybe help — GNassro, Aug 14 '20 at 18:06
As the instructions say you have to add the path where the Instant Client is to your path. It doesn't really matter where it is installed but its location MUST be in the system path. — Dave, Aug 14 '20 at 18:12
C:\oci8-2.0.12\instantclient_19_8 C:\oci8-2.0.12\instantclient_11_2 Added both versions, separately — AAM, Aug 14 '20 at 19:55

score 1 · Accepted Answer · answered Aug 14 '20 at 18:35

1

I had the same issue but with mysqli_connect()

I removed and did autoremove the webserver and php and reinstalled them again, and it worked.

answered Aug 14 '20 at 18:35

Zeko

105
1
10

How to fix error "Uncaught Error: Call to undefined function oci_connect()" in wamp server?

1 Answers1