Hi all, i'm working with stored procedures. When i create one using:
DROP PROCEDURE IF EXISTS returnAccounts; DELIMITER // CREATE PROCEDURE returnAccounts() BEGIN SELECT * FROM account; END
and run it with:
CALL returnAccounts();
i get the following error from SQL Explorer:
"PROCEDURE test.returnAccounts can't return a result set in the given context"
What am i doing wrong?
Thanks in advance
best regards Fernando Gabrieli
Log in to post a comment.
Hi all, i'm working with stored procedures. When i create one using:
and run it with:
i get the following error from SQL Explorer:
"PROCEDURE test.returnAccounts can't return a result set in the given context"
What am i doing wrong?
Thanks in advance
best regards
Fernando Gabrieli