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!
I thought like that , but not :) with semicolon would be another type of ora-issue :)
Your "Database type" property is set to "Generic", try setting it to Oracle (for Oracle < 12) or Oracle 12+.