Stored Procedure Error
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!
Subject
Views
Written By
Posted
Stored Procedure Error
2180
May 16, 2011 11: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.