Access denied when using stored procs
Posted: Sat Apr 21, 2007 5:34 pm
There are actually to issues... one is syntax one is access... When I do the following
I receive a syntax error for the 'select...' (note, im using query browser to excute this)..
Now when I do this..
any ideas?
Thanks!
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!