PROCEDURE can’t return a result set in the given context

iteye_732

于 2012-08-29 12:11:31 发布

阅读量248

点赞数

CC 4.0 BY-SA版权

分类专栏： mysql PHP 文章标签： c# 数据库 php

本文链接：https://blog.youkuaiyun.com/iteye_732/article/details/82405110

PHP 同时被 2 个专栏收录

19 篇文章

订阅专栏

mysql

2 篇文章

订阅专栏

本文介绍了解决在调用MySQL存储过程时遇到无法返回结果集的问题。通过更换使用mysqli系列函数替代mysql系列函数，成功实现了从存储过程中获取结果集。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

PROCEDURE db.procedure_name can't return a result set in the given context

Of course ‘db.procedure_name’ was the actual name of the procedure I was calling. Googling for the error seemed to indicate that the MySQL client library was old, but this is on a fairly modern CentOS 5.5 server with the php-mysql package at version 5.1.6.

After a bit of experimenting, I found that I was able to change to using the mysql improved versions of the PHP functions and that worked fine

     $dbconn = mysql_connect($dbhost, $dbuser, $dbpass);
     $result = mysql_query("CALL db.procedure_name('arg1', 'arg2', 'arg3')", $dbconn)
     $row    = mysql_fetch_assoc($result);

Becomes

    $dbconn = mysqli_connect($dbhost, $dbuser, $dbpass);
    $result = mysqli_query($dbconn, "CALLdb.procedure_name('arg1', 'arg2', 'arg3')");
    $row    = mysqli_fetch_assoc($result);