While extracting the data from oracle source I'm trying to add oracle current_timestamp to my output in Nifi and i'm using the generate table fetch processor and them i'm connecting to execute sql processor to execute the query generated by the generate table fetch. while executing the execute sql processor i'm getting the below error.
ORA-000923:From key word not found where expected.
Attached the screenshot.
Please provide some inputs. Thanks in advance !!!
this error is from the DB, so Nifi is running the SQL, I think you have to check the syntax. Try running the sql query on sqlclient to verify first.