In PostgreSql 7.2,
i have written one stored procedure using CURSORS.
CREATE FUNCTION reffunc3(refcursor) RETURNS refcursor AS '
BEGIN
OPEN $1 FOR SELECT empName FROM tbl_employee;
RETURN $1;
END;
' LANGUAGE 'plpgsql';
BEGIN;
SELECT reffunc('funccursor');
FETCH ALL IN funccursor;
COMMIT;
** Function is created successfully
** While executing the SELECT of function,it is returning the
Cursor
** While using the FETCH ALL IN Command ,it is simply saying
"Query Execuetd OK!"
How can i get the Result sets ?
Sudharsan