#3634 select in stored procedure returns error #1312

3.4.10
fixed
nobody
5
2013-06-11
2012-07-03
No

I create a very simple procedure whit only one SELECT

CREATE PROCEDURE `seleziona`()
SELECT Nome FROM utenti;

And then I call it

CALL seleziona;

in local machine no problem
phpMyAdmin 3.4.9 server Apache 2.2.21 (Win32) PHP 5.3.9 MySQL 5.5.20-log

But in production online server
phpMyAdmin 3.4.10.1 server Apache 2.2.22 PHP 5.3.10 MySQL 5.1.56-log
when from SQL window I call this procedure (or every other with a select statement ) phpMyAdmin returns the error
#1312 - PROCEDURE my_database.seleziona can't return a result set in the given context

Discussion

  • Michele Salvador

    • milestone: --> 3.4.10
     
  • Michele Salvador

    I started using phpMyAdmin latest version 3.5.1
    this problem of the SELECT in routines seems to have fixed.
    :-)

     
  • Marc Delisle

    Marc Delisle - 2012-07-06
    • status: open --> closed
     
  • Marc Delisle

    Marc Delisle - 2012-07-06

    Great!

     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed --> fixed
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks