Calling Oracle Stored Procedure with ODBC with PHP

Happy_Camper · 05-06-2011, 07:18 PM

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!

Fou-Lu · 05-06-2011, 11:51 PM

Looks to me like the PDO can be used to call a stored procedure in an oracle with INOUT - best I know the ODBC only does in as you discovered. There is a driver for it as well, so you could start looking there:
http://php.net/manual/en/pdo.prepared-statements.php
http://www.php.net/manual/en/ref.pdo-oci.php

Unfortunately the PDO oracle driver is a new guy on the block, so it is experimental.

Happy_Camper · 05-09-2011, 03:28 PM

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!

Fou-Lu · 05-09-2011, 04:36 PM

Quote:

Originally Posted by Happy_Camper

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!

You betcha.
I'd rewrite an abstraction layer if I were you, that way you can swap out the OCI8 with the PDO-OCI once its moved above experimental without modifying most code. Done right, it would be a simple implementation class rewrite to overtake the new drivers instead of the old.