Getting error "ORA-00900:invalid SQL statement" when running a Data Report with a valid SQL statement.
There is a comment at the beginning of the SQL in the Data Report SQL:
---This is a comment
SELECT a,b,c
FROM table
The data report is only expecting a single SQL so it errors.
WORKAROUND 1
Embed the comment in the SQL Statement.
Instead of
---This is a comment
SELECT a,b,c
FROM table
use
SELECT a,b,c
---This is a comment
FROM table
WORKAROUND 2
Remove the comment
STATUS
Waiting for fix in a future release of Toad Data Point
