Getting Stored Procedure Results to a .NET Application

I have the following procedure:

CREATE OR REPLACE Procedure PROACTV4.psp_GetResources(
vsWhere in varchar,
aData out SYS_REFCURSOR
)
As
vstr varchar2 (2000);
Begin
Select 'Select r.*,0 as AllowCreate, 0 as SiteAdmin, 1 as GlobalAdmin, 0 as RMProUser,s.FacilityName From tbl_LK_Facilities s Join tbl_LK_Resources r On s.FacilID=r.SiteID Where UserActive=1 And (ResourceID In (Select ResourceID From tbl_AdminUsers Where AdminType=0)) ' || vsWhere || '
Union
Select r.*,0 as AllowCreate, 1 as SiteAdmin, 0 as GlobalAdmin, 0 as RMProUser,s.FacilityName From tbl_LK_Facilities s Join tbl_LK_Resources r On s.FacilID=r.SiteID Where UserActive=1 And (ResourceID In (Select ResourceID From tbl_AdminUsers Where AdminType=1))' || vsWhere || '