Yesterday I received this error: “ORA-0933: SQL command not properly ended” but the SQL runs any where outside Lucee (DBeaver, CFusion, SQL Developer).
4 hours later I solved the problem, and I concluded that you cannot use the “result” attribute of the cfquery to do an insert into an Oracle temporary table.
When I changed the tmpTable with a phisical table, there was no problem.
When I did the insert to the tmpTable, but without the attribute result, there was no problem.
Regards.