Getting issue in mysql Procedures

Asked Aug 09 '12 at 05:52

Active Aug 09 '12 at 06:29

Viewed 62 times

Below is the code I have used for creating a MySQL procedure:

DELIMITER //
CREATE PROCEDURE GetAllComments()
  BEGIN
    SELECT * FROM comment;
  END //
DELIMITER ;

This procedure has been executed correctly, except when I'm trying to call procedure (CALL GetAllComments()) it is giving me the error below:

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

What could be the issue?

edited Aug 09 '12 at 06:29

Ajay Kadyan

asked Aug 09 '12 at 05:52

Vee Mandke

which mysql version you are using? – Ajay Kadyan Aug 09 '12 at 05:59
1

may be its version bug cause on 5.3 and later version its not creating any issue. – Ajay Kadyan Aug 09 '12 at 06:06
2

See http://stackoverflow.com/q/2360371/161052 – JYelton Aug 09 '12 at 06:28

0 Answers0