I am trying to write a generic PL/SQL procedure for use by the Oracle Application Server [Web server] where I can generate HTML to display data in all columns of a cursor. Generating the HTML is no problem if I hard-code the column names. What I want to do is be able to do this with any cursor that would have variable number columns and column names. Is any one familiar with how to loop through the columns in an Oracle cursor without knowing the column names plus output the data in each column like we can in VFP with the afields(), fcount() and field() functions?
TIA!
Mark McCasland
Midlothian, TX USA