Stored Procedures Help
Posted: Mon Apr 21, 2008 10:15 am
i created a stored procedure
then when i CALL it,
it says
Code: Select all
CREATE PROCEDURE GET_USER_ACL_BY_USERNAME (IN USR VARCHAR(255))
BEGIN
SELECT ACL.Action, ACL.Path FROM ACL
WHERE ACL.UserGroup
IN (
SELECT Usergroup.GroupID
FROM Users, UserGroup, Privilages
WHERE Users.UserID = Privilages.UserID
AND Usergroup.GroupID = Privilages.GroupID
AND Users.UserName = USR
);
END|Code: Select all
CALL GET_USER_ACL_BY_USERNAME ('emp1')whats wrong? how can i fix this? i just started stored procedures... and recommendations for Stored procedures resources at the same time?#1312 - PROCEDURE employeemanager.GET_USER_ACL_BY_USERNAME can't return a result set in the given context