MySQL Forums
Forum List  »  Stored Procedures

Stored Procedure Error
Posted by: Leonid Sklyut
Date: May 16, 2011 11:11AM

I am having trouble setting up simple stored procedures. I create a procedure as follows:

DELIMITER //
CREATE PROCEDURE test()
BEGIN
SELECT * FROM products;
END //
DELIMITER ;


and call it using:

CALL test();

but I receive the following error:

#1312 - PROCEDURE carpool_db.test can't return a result set in the given context

Is this a phpmyadmin bug? or am I doing something wrong?

Thanks a lot!

Options: ReplyQuote


Subject
Views
Written By
Posted
Stored Procedure Error
2180
May 16, 2011 11:11AM
699
May 17, 2011 01:06AM
629
May 17, 2011 03:11AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.