Getting output from a procedure using oracle databases - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20) +--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23) +--- Thread: Getting output from a procedure using oracle databases (/showthread.php?tid=60500) |
Getting output from a procedure using oracle databases - El Forum - 04-09-2014 [eluser]Unknown[/eluser] Hi Guys, I've hit a bit of a roadblock in my CI application. I want to bind the output of an Oracle procedure to a PHP variable using Codeigniter. Suppose this is my procedure: Code: CREATE OR REPLACE PROCEDURE myproc(p1 IN NUMBER, p2 OUT NUMBER) AS If I was doing this purely with oci8 functionality I could get the output this way: Code: $p1 = 8; (example adapted from example 11) Is there a way I can achieve this using the oci8 driver and database class in Codeigniter? I've looked around and I've had no luck yet. Many thanks in advance. |