MySQL Forums
Forum List  »  Stored Procedures

Problems creating a stored procedure
Posted by: david larkin
Date: February 01, 2006 08:43AM

Hi,

I'm creating a procedure and then trying to execute it. However I keep getting "error 1305: procedure does not exist". But, when I query the information_schema table the procedure is there. Also, if I try to create a procedure with the same name I get "error 1304: procedure already exists". I'm trying to execute the query from the same database I created it in.

It's a very simple query as follows:

CREATE PROCEDURE `SP_GetUserInformationByUserID`(iUserID INTEGER)
BEGIN
Select * From user Where user_id = iUserID;
END;

Any suggestions?

Thanks very much

Options: ReplyQuote


Subject
Views
Written By
Posted
Problems creating a stored procedure
3821
February 01, 2006 08:43AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.