The error does not show up when there is no data aware component (DBGrid, RxDBGrid) being linked to the query (TOracleDataset)!
Also, the error only occurs with "CountAllRecords" being set to True and with DOA 3.4.3.
The DOA 3.4.6 does not show this error!
Using a substitution variable in TOracleDataset SQL with a value of
' ORDER BY 1 ASC' does result in
"ORA-00907 missing right parenthesis ."
when opening the DataSet.
Setting the variable to a single blank
this message does not show up.
The variable name used was :SORT, but error happens also...