--------------------------------------------------------------------------------
我在调用sybase的存储过程时:
$sql = "declare @retu int,@interval int ,@err_msg varchar(200),@period int,@feast_p int\n";
$sql.= "exec circul.renewal '$barcode','$departid','$userid',@retu output,@interval output,\n";
$sql.= "@err_msg output,@period output,@feast_p output \n";
$sql.= "select retu=@retu ,err_msg=@err_msg ";
$query=sybase_query($sql);
$array = sybase_fetch_array($query);
echo 'sybase_num_fields :'.sybase_num_fields($query) .' ';
echo 'sybase_num_rows :' .sybase_num_rows($query).' ';
echo $array[0] .' ';
发现取得的结果集只有一行一列,即为:0。相当于只取到了返回的状态值,而没有取到我想要的retu和err_msg的值!
请问各位高人,应该怎样才能取到我想要得到的参数值?
谢谢!
|