Problems creating a stored procedure
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
Subject
Views
Written By
Posted
Problems creating a stored procedure
3821
February 01, 2006 08:43AM
1447
February 01, 2006 10:17AM
1244
February 01, 2006 10:29AM
1247
February 03, 2006 09:00AM
1405
February 03, 2006 10:20AM
1287
February 02, 2006 04:38AM
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.