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>)