Order by must be construct by variable

Hi

I don't want use DBMS_SQL (Code translation of my query to DBMS is too hard, 700 lines ... hum)

For example i want to create my query
SELECT * FROM T WHERE ... ORDER by Buff

Is there a way to compute order by in buff
=> CURSOR C1(buff) Is SELECT * FROM T WHERE ... ORDER by Buff;
begin
 buff := field1 ASC, Field2 DESC;
 OPEN C1(buff);
 ....
end;

if no solution i'll go in DBMS_SQL but not cool for this query.

Besrs regards
Oraclion Received on Sat Mar 15 2003 - 10:20:32 CST