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;