gbase存储过程

 

DELIMITER $$

DROP PROCEDURE IF EXISTS getRecord $$
CREATE PROCEDURE getRecord (
IN in_id INTEGER,
OUT out_name VARCHAR(20),
OUT out_age  INTEGER)
BEGIN
   SELECT name, age
   INTO out_name, out_age
   FROM Student where id = in_id;
END $$

DELIMITER ;