APEX

Hi everyone,

I am wondering if there is a way to supply the ORDER BY clause with an Apex item's value? For example, if I have a Select List item (P1_ITEM) and select the PERSON_NAME column, how to specify something like this correctly:

select PERSON_NAME, PERSON_AGE 
from MY_PERSON_TABLE
order by :P1_ITEM;

When I tried the syntax above, my generated Classic Report did not order the returned result...

Btw, I do not use the built-in Classic report's ordering feature (by clicking the column's name) because we want to remove all AJAX call (the security auditor said using AJAX won't comply with the company's security policy).

Thanks in advance.