Column reference in PL/SQL

I would like to know how to reference a row by column number. For instance instead of

fetch cursor into record;
returnvalue = record.column_name;

I would like something like

fetch cursor into record;
returnvalue = record.column[1];

This would allow me to write a dynamic column fetch routine.

Patrick Lanphier
Advanced Information Technologies
The Pennsylvania State University Received on Mon Oct 04 1999 - 11:11:51 CDT