Search

Oracle error was `ORA-00911: invalid character

Liz Sanderson
Liz Sanderson
  • Updated

Symptom

Executing a SQL Query in the Oracle reader, OracleQuerier or other FME transformer returns an error:

error was `ORA-00911: invalid character

Cause

This can be caused by including the semi-colon (;) on the SQL statement, or possibly inserting TABs and other special characters that may be included in the SQL statement if you have cut and pasted from a SQL editor.

Resolution

Remove the ';' or other special characters for single line SQL statements.

The FME "SQL Statement to Execute Before/After Translation", SQLCreator, and SQLExecutor (retired SQLQuerier) do support multiple SQL statements.

In this case include the FME_SQL_DELIMITER <delimiter> as the first line in the SQL block (typically the delimiter is a semi-colon ";").

Was this article helpful?

We're sorry to hear that.

Please tell us why.

As of January 14th, 2026, comments on knowledge base articles have been closed. To make sure questions don’t get missed and to enable more community support, we’ve moved discussions to the FME Community. If you have a question or a comment about this article, please create a new post or create a support ticket.