Dynamic "Orde by" parameter in Oracle Stored procedure

I would like to execute a SELECT * from table1 order by <XYZ> and get the results into IN OUT cursor.

I want to pass XYZ as input parameter to stored procedure. It is treating it as string.

For example: if XYZ value is field1, it is executing the SQL statement as
SELECT * from table1 order by 'field1'
instead of
SELECT * from table1 order by field1

Please help. Received on Mon Aug 16 2010 - 13:51:34 CDT