在存储过程体内写上
DECLARE clientcur CURSOR WITH RETURN TO CALLER;
FOR SELECT name, dept, job FROM staff
WHERE salary > 15000;
OPEN clientcur;
在存储过程体内写上
DECLARE clientcur CURSOR WITH RETURN TO CALLER;
FOR SELECT name, dept, job FROM staff
WHERE salary > 15000;
OPEN clientcur;