Getting error "ORA-00936: missing expression" in automation task. The query there works fine in the editor.
This happens when adding the Database Activity "Export to File" with a query that includes commented code as for example
select 1,
2,
--decode (comm,'a',1,2)
3
from dual
WORKAROUND 1
Remove the commented code .In the example the code would be:
select 1,
2,
3
from dual
WORKAROUND 2
Use the older C style comments /* */ instead of the -- ones. In the example the code would be:
select 1,
2,
/*decode (comm,'a',1,2)*/
3
from dual
STATUS
Issue fixed in version 4.0. The latest version of Toad Data Point can be downloaded at: https://support.quest.com/toad-data-point/download-new-releases
