question NiFi + Oracle: ORA-00933: SQL command not properly ended in Archives of Support Questions (Read Only)

NiFi + Oracle: ORA-00933: SQL command not properly ended

acoast83 — Fri, 19 Oct 2018 15:09:46 GMT

Hi guys! I have an issue in NiFi when I do this query in it SELECT * FROM my_db.my_table - the issue - [ORA-00933: SQL command not properly ended]. I don't understand what I need to do to fix this issue because in sql_client this query works well. I use QueryDatabaseTable processor. Is any suggestion for this? Thanks!

Re: NiFi + Oracle: ORA-00933: SQL command not properly ended

Shelton — Fri, 19 Oct 2018 15:15:33 GMT

@Alex Coast

I think the Oracle SQL syntax expects a semicolon at the end eg

SELECT * FROM my_db.my_table;

Can you try that and revert

Re: NiFi + Oracle: ORA-00933: SQL command not properly ended

acoast83 — Sun, 18 Aug 2019 02:15:21 GMT

I've fixed! 🙂 See an attach image.Custom Query not needed.

Re: NiFi + Oracle: ORA-00933: SQL command not properly ended

acoast83 — Fri, 19 Oct 2018 15:34:23 GMT

I thought like that , but not 🙂 with semicolon would be another type of ora-issue 🙂

Re: NiFi + Oracle: ORA-00933: SQL command not properly ended

mburgess — Sat, 20 Oct 2018 00:54:20 GMT

Your "Database type" property is set to "Generic", try setting it to Oracle (for Oracle < 12) or Oracle 12+.