Mysql Stored Procs

[Network_ninja]

Hi everyone... I decided to use Mysql Stored Procs but i don't find a complete tutorial on how this things work.

But I already started creating one:

 

Here is my simple SP:

;
CREATE PROCEDURE GetAllProducts()
  Select * FROM products 
;

 

Question 1:

Whenever I use this piece of code CALL GetAllProducts(); it will give me an ERROR 1312: PROCEDURE stored_procs. GetAllProducts can't return a result set in the given context

 

Question 2:

How do i display the created stored procs again.. so that I can review the code or modify the code.

 

By the way I am using Mysql Control Center as my UI. Tnx in advance.

[fenway]

This question came a while ago -- something with a php setting that controls this behavior...but I don't recall the details.  It's on the forum, somewhere.