I’m trying to connect to an Oracle DB using PHP, ODBC, and calling a stored procedure that contains IN and OUT params. PHP contains ODBC functions that will work for Oracle stored procedures with IN parameters, but does not have anything for OUT parameters. PHP’s documentation states to use the OCI8 driver, which I’ve gotten to work before, but our sys admin cannot get the OCI8 driver to work anymore. So, I’m stuck with trying ODBC. Does anyone know how to do this? Is it possible? Thanks for the help!
What error is returned? If you are getting a ‘connection refused’ make sure the port is open on the server and allowed on the firewall [if applicable].
After looking at ODBC and seeing that it wasn’t able to pass out parameters we decided that we would have to get the OCI 8 driver to work. After a couple hours the sys admins were able to get it to work. Thanks for the help!