Skip to main content
Skip table of contents

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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.