Welcome Guest, Not a member yet? Register   Sign In
How to call a Stored Procedure with 'out' parameter
#4

[eluser]Unknown[/eluser]
[quote author="abdul mohsin" date="1321120954"]but i did not get how i can access the value of the OUT parameter and use in my php file>[/quote]

Code:
$sql = "call int_MapColumnToCustomFields(?,@x);";
        $params = array($id);
        $this->db->query($sql, $params);
$sqlGetOutParam = "SELECT @x;";
$outValue = $this->db->query($sqlGetOutParam);

echo "<pre>";
print_r($outValue->result());
echo "</pre>";

Hope you will get it.


Messages In This Thread
How to call a Stored Procedure with 'out' parameter - by El Forum - 06-28-2011, 03:22 PM
How to call a Stored Procedure with 'out' parameter - by El Forum - 06-28-2011, 03:28 PM
How to call a Stored Procedure with 'out' parameter - by El Forum - 03-15-2012, 02:39 AM
How to call a Stored Procedure with 'out' parameter - by El Forum - 12-14-2012, 09:45 PM



Theme © iAndrew 2016 - Forum software by © MyBB