Error compiling the test code when using a query as Expected Results with an ORDER BY clause: "OR (4220931)

A test definition was created for  a procedure. A Query outcome result was created for the definition and it's value was to "select  <column name>  from <table name> order by <column name>". Test code has the following compilation error when attempting to run it. If the Order BY clause is taken out, test code runs fine.

ORA-06550: line 3, column 3: PL/SQL: ORA-00907: missing right parenthesis
ORA-06550: line 1, column 7:PL/SQL: SQL Statement ignored

Expected result = Query
Properties of result=select <column name> from  <table name>  order by <column name>

Using an ORDER BY in a Query Expected Result is currently a restriction in Code Tester. However, including an ORDER BY clause is not necessary because the ordering  will not  affect the outcome, as SQL is a set-oriented language.

In order to leave the ORDER BY clause, it has to be used in the following fashion:
select * from (select <column name list> from <table name> order by <column name>)