Can I use cursors inside plpgsql functions?.
CREATE FUNCTION test() RETURNS text AS '
BEGIN
BEGIN WORK;
DECLARE emp_cur CURSOR FOR SELECT * FROM hpemployee;
FETCH FORWARD 2 FROM emp_cur;
CLOSE emp_cur;
COMMIT WORK;
END;
'language 'plpgsql';
The above code gives me error "parse error at or near by CURSOR"
Thanks in advance
CREATE FUNCTION test() RETURNS text AS '
BEGIN
BEGIN WORK;
DECLARE emp_cur CURSOR FOR SELECT * FROM hpemployee;
FETCH FORWARD 2 FROM emp_cur;
CLOSE emp_cur;
COMMIT WORK;
END;
'language 'plpgsql';
The above code gives me error "parse error at or near by CURSOR"
Thanks in advance