PHP call Stored Proc with parameters returning recordset
I have used mssql & ASP for years and can easily call a SP, pass parameters and return a recordset. However, I am now trying to learn to use PHP & MYSQL. I have searched and cannot get to work. I can from my PHP pages call a SQL statement and output the recordset no problem. However, if I set SQL = "call sp( param1, param2), i get no results. if I from SP from mysql I get a result set.
I have tried mysqli which I read is obsolete??? the PDO I can't find example for me. I see examples that call sp w/o parameters and so forth.
I never imagined to do this would be so challenging and maybe it is just me.
please somebody with example
thanks
Subject
Written By
Posted
PHP call Stored Proc with parameters returning recordset
May 09, 2015 06:24AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.