Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
Contributor

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!

1 ACCEPTED SOLUTION

avatar
Contributor
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
4 REPLIES 4

avatar
Master Mentor

@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

avatar
Contributor

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

avatar
Contributor
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login

avatar
Master Guru

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