hi
following is my SP
it will not allow me to compile
-------------------------------------
declare varable1 integer;
DECLARE c1 CURSOR WITH RETURN FOR
Select max( coln1) From Tab1 WHERE coln1=17 ;
OPEN c1;
fetch c1 INTO verable1;
CLOSE c1;
SELECT coln1,varable1 FROM tab1;