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)