FME Form 2025.1
SQL Query in SQLExecutor:
SELECT * FROM table_name WHERE ID BETWEEN $(polystart) AND $(polyend);Oracle table
Works fine in DBeaver with actual ID numbers
Fails in FME with actual ID numbers
Fails in FME with User Parameters for the numbers
Error Message:
Execution of statement `SELECT * FROM table_name WHERE ID BETWEEN 35480 AND 35484;' did not succeed; error was `ORA-00933: SQL command not properly ended'.
Does FME just hate a BETWEEN statement?
Going mad trying to figure out where I am going wrong 😂


