CREATE PROCEDURE usera.proc_1
@FromDate datetime,  
@ToDate  datetime
AS
SET XACT_ABORT ON
select count(status) TotalOrders, country,
status = 
CASE status
    WHEN 'I' THEN 'Invalid' 
    WHEN 'S' THEN 'New' 
    WHEN 'P' THEN 'In Process'
    ELSE 'Other'
END 
from usera.table1 WITH (NOLOCK)
where DeliveredTime BETWEEN @FromDate AND @ToDate
AND status != 'F'
group by country, status
order by country, status

declare
pendord_rc        sys_refcursor;
lv_ord_cnt        NUMBER;
lv_country		  VARCHAR2(100);
lv_status	      VARCHAR2(100);
begin
	pendord_rc := "usera".proc_1@HET_LINK.WORLD;
	loop
		fetch pendord_rc into lv_ord_cnt, lv_country, lv_status;
	    EXIT WHEN pendord_rc%NOTFOUND;
	end loop;
end;
/