Bug #63945 procedure not working
Submitted: 6 Jan 2012 6:18 Modified: 6 Feb 2012 6:55
Reporter: sumit sharma Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Stored Routines Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[6 Jan 2012 6:18] sumit sharma 
Description:
DELIMITER // 
CREATE PROCEDURE getchgp(in ol varchar(100),in nw varchar(100),in sch varchar(100),in out res varchar(100))
BEGIN
SELECT pass INTO res FROM registration WHERE pass=ol AND schno=sch;
UPDATE registration SET pass=nw WHERE schno=sch AND pass=ol;
END //
DELIMITER ;

why this procedure is not working 

How to repeat:
why this procedure is not working even it executed successfully , but when i am call this procedure getting mgs that this procedure not exists.
[6 Jan 2012 6:55] Valeriy Kravchuk 
Please, specify the exact server version used, 5.x.y, and provide other missing details, like CREATE TABLE and sample data for that registration table, exact CALL statement used and the output you get from the mysql command line client.
[7 Feb 2012 1:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".