WELL I AM TRYING TO DO THIS BUT NOT GETTING ANY RESPONSE FORM SERVER

DELIMITER //
CREATE PROCEDURE getchgp(in ol varchar(100),in nw varchar(100),in sch varchar(100),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 ;

PLEASE HELP ME OUT ..............

Try to find the shift key on your keyboard and unlock it.
What response do you expect from the server?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.