ORA-00933: SQL command not properly ended

One Star

ORA-00933: SQL command not properly ended

Hi, I face a similar problem. My job flow is tOracleIput-->tJavaRow-->on component ok-->tOracleInput-->tOracleOutput. I am giving a query in toracleinput component : "SELECT * FROM incr_source where incr_source.invoice_date > "+context.incrementaldate+""
It gives me an error saying: Exception in component tOracleInput_2
java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
What is the correct syntax? Please help. Thanks
Community Manager

Re: ORA-00933: SQL command not properly ended

Hi 
What's data type of invoice_date field? Make sure the value of context.incrementaldate is not null or empty. For testing, print the value of context.incrementaldate on tJavaRow.

Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business