It depends on how do you call the procedure:
'execute procedure getnames' gives you only one record
you should rather use select statement:
'select * from getnames' will work fine, but in this particular case
it's enough to use simple select from inside the procedure :)

Marek