Code: Select all
CREATE PROCEDURE sp_get_category()
BEGIN
SELECT category_id FROM categories;
END;Now when I do this..
I receive access is denied. If I do the select outside of a procedure, then it executes fine, and i'm connected to that DB, so not sure why I would get that.CREATE PROCEDURE sp_get_category()
BEGIN
END;
any ideas?
Thanks!