newble ~~help me!!

[dennis su]

dear all :
i write a sp but it doesn't work
------------sp begin--------------------------

CREATE PROCEDURE `acm`.`login`( in login varchar(8),in pwd varchar(16))
BEGIN
SELECT A.USER_ID,A.USER_NAME,A.GROUPID,B.ISOFFICER,B.DEPI,B.EMPI FROM CUSER A ,EMPLOYEETB B
WHERE (A.USER_ID=B.USER_ID) AND A.USER_ID=UPPER(LOGIN) AND A.PASSWD=UPPER(PWD)
END

------------sp end-------------------------------
when i stored it
the error message shows <<can't create a procedure from within another stored routine!!>>

may somebody show me how to modify my sp ?? please give a hand!!
thank you all



Edited 1 time(s). Last edit at 12/18/2006 12:55AM by dennis su.