Re: Stored procedure

[praba karan]

thanks Peter Brawley

Its working

but we are using PEAR DB Package.
In pear db above stored procedure have some problem;

WE are calling the stored prcedure as follows

$db = getDBHandler();
$res = $db->getAll("call storedPrcedureName($inParameter,@ourParameter)");
if (PEAR::isError($res))
{
echo "<pre>" ;
print_r($res);
}
else
{
echo "<pre>" ;
$res =$db->getAll("select @ourParameter");
print_r($res);
}



I am getting error as follows


[userinfo] => call exampleProcedure() [nativecode=1312 ** PROCEDURE mzapp.mzappNew can't return a result set in the given context]