How to solve Oracle exception ORA-00933: SQL command not properly ended
When using an Oracle database as datasource, you might come across the following error (printed when enabling "Debug Mode" at the PocketQuery macro):
Error Details
Type: BadSqlGrammarException
Message: PreparedStatementCallback; bad SQL grammar [SELECT* FROM mytable;]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
This can be solved by removing the semicolon at the end of the query statement. The semicolon will be added automatically during execution and Oracle does not accept the resulting duplicate semicolon.