sort web screen 16 different ways

My business user wants to show 16 columns of data on a web screen with each column able to be the sort field. I am using plsql in a 7.3.4 database to generate the web pages. I have been using cursors each with a different order by clause with the same "select field1, field2, etc from ..... where...." part in other screens with less sort options..

Is there a "best" way to code this so I don't have to have 16 cursors all defined the same except for the order by clause and 16 if statements to open the right one and 16 if statements to fetch the right one and so on?

-Dynamic dbms_sql doesn't seem too good since there are so many fields
to bind to.
-A plsql table to hold the data would still need to be sorted on the
right field unless there is a sort function for plsql tables.

Any ideas?

thanks, Dave Rawding Received on Mon Jan 29 2001 - 21:56:10 CST