ORA-00933: SQL command not properly ended

[Anonymous]

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

[Anonymous]

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