IT Solutions Technology Blog

In Oracle ending a query with a semicolon inside a client application like n8n often triggers the „ORA-00933: SQL command not properly ended“ error

The Fix – simply delete the ‚;‚ at the end of your SQL statement in the Oracle Database node

Wrong:  SELECT * FROM users;
Right:    SELECT * FROM users

Why this happens – in n8n the SQL is sent via a driver (like node-oracledb) and drivers treat the semicolon as a statement terminator for scripts but when sending a single command via an API the semicolon is seen as an illegal character within the command itself

Oracle’s documentation classifies this as an invalid character (ORA-00911) or an improperly ended command (ORA-00933)