CREATE PROC SP_FetchData() as begin select FirstName, LastName from TBl_Users; select TaskId,CreatedBy from TBl_Log; END;
CREATE FUNCTION SP_FetchData() RETURNS setof refcursor AS $$ DECLARE c1 refcursor; DECLARE c2 refcursor; BEGIN OPEN c1 FOR select FirstName, LastName from TBl_Users; RETURN NEXT c1; OPEN c2 FOR select TaskId,CreatedBy from TBl_Log; RETURN NEXT c2; END; $$ LANGUAGE 'plpgsql';
UNION ALL
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)