ORA-000923:From key word not found where expected error in Apache NifI

[#1]

Hi All,

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 !!!

[#2]

Hi,

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.

[#3]

@Sharath V

I think your SQL syntax is not correct

SELECT *,SYSDATE as Extract_date from XXXXX 

This should be something like

Select sysdate, a.* from tablex a

Hope that is a good pointer