Is there a way to enumerate fields in the result set of a select
statement in a procedure? I have a table with 20+ fields, and want to
return them one by one:

for select * from tablename do
for each field in result_set do
begin
resultvariable=field.value;
suspend;
end

alternatively,

select * from tablename into :my_array
for each field in my_array do
begin
resultvariable=field.value;
suspend;
end


Is something like this possible?