Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Column Collection?
Message
 
 
To
All
General information
Forum:
Oracle
Category:
PL/SQL
Title:
Column Collection?
Miscellaneous
Thread ID:
00693685
Message ID:
00693685
Views:
74
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
Next
Reply
Map
View

Click here to load this message in the networking platform