Anybody know if the following code could be simplified?

select dist site_id from training into cursor crstemp
select dist reccount() as sitesrepresented from crstemp into array aSitesRepresented


The need is to get a single number that will be used in a report. The above works and the array appears to be global, but I was not overly comfortable with the solution.

Thanks