SQL & PL/SQL

Hello,

I have a stored procedure like follows where p_cursor IN OUT cursor

thissql := 'SELECT distinct ';
thissql := thissql || 'name, age, height ';
thissql := thissql || 'from table';
thissql := thissql || 'where name = '''|| trim(p_inputName) ||''' ';

open p_cursor FOR thissql;

begin
   execute immediate thissql;
end;

Now the above is used to go back to asp.net where I go thru the cursor.

BUT, what I want to do with the above is instead of returning a cursor, I want to either loop thru the cursor for the 1 row and take out name age and height... or do away with the cursor... but 'into' won't work for this...