Using dynamic order by clause(using Decode) in Forms 4.5

Syntax is

SELECT fld_name1,fld_name2
FROM table_name
[Quoted] [Quoted] ORDER BY DECODE(var_name,1,fld_name1,2,fld_name2);

It runs under SQL*PLUS. When we write this code in PL-SQL editor of Forms 4.5 it doesn't give any compilation error. But at runtime it gives ORA error saying Invalid field name.

Please reply soon. It is very urgent.

Thanks.

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet